none
Need info for resource table RRS feed

  • Question

  • Hi

       I am the Administrator for Project Server 2010. One of the user requested that total no of resources and their permissions.

     Total no of resources i took from MSP_Resources table (Publish Database)

    My question is how to retrive the permission for each corresponding resources (name of the group)

    Note:  We are working only with Groups

    So i would like to know resources belongs to which group

    Let me know anything else you need to from my side

     

    Regards

    Santosh

    Monday, December 17, 2012 7:25 AM

Answers

  • Hi Santosh,

    official answer:

    You should use PSI web services for that and do not touch the published database directly.... :-)

    Apart from that:

    You will need the security tables in the published database.

    Example query for getting only active group members:

    SELECT     SG.WSEC_GRP_NAME, R.RES_NAME
    FROM         MSP_WEB_SECURITY_GROUP_MEMBERS AS SGM INNER JOIN
                          MSP_WEB_SECURITY_GROUPS AS SG ON SGM.WSEC_GRP_GUID = SG.WSEC_GRP_GUID INNER JOIN
                          MSP_RESOURCES AS R ON SGM.WRES_GUID = R.RES_SECURITY_GUID

    where r.res_type <=2
    order by 1,2

    Hope that helps

    Kind regards

    Christoph

    Tuesday, December 18, 2012 8:46 PM