Query on tables (data model) in PROJECT SERVER published database.

01 Juli 2010 16:05

I have to create reports for the following circumstance, could any one help on finding the corresponding tables in PROJECT_SERVER_2007_Published_Database

List of Users								1
List of Security Groups
Members of the Groups
Permissions of the Groups
Security Category options								2
Names of All Views
Categories of each Veiws
Custom Fields and the Lookup tables								3
Values of the Lookup tables of the Fields

Thanks

Bob

Semua Balasan

01 Juli 2010 18:12

Pemilik

0
Bob you should be leveraging PSI calls to query data from the Published database
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
- Ditandai sebagai Jawaban oleh Christophe FiessingerMicrosoft Employee, Owner 01 Juli 2010 18:13
- Balas
- Kutip
01 Juli 2010 18:47

0

Hi Chris,

Thanks and Appreciated for your quick response. The idea behind this request is to generate the reports where it gives all the PS Groups, Members of groups, permission for each groups and the categories with their permission.

So it will be great if I find the SQL query for generating these reports.

Thanks

Bob
- Balas
- Kutip