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
01 Juli 2010 18:12PemilikBob 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
01 Juli 2010 18:47
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.