none
Create a User and Security Group Report in Project Server 2013 RRS feed

  • Question

  • Hi All,

    I am trying to create a report that defines which security groups users are in and I can only find references to 2010 online?

    Is there is simple query that will bring back the results?

    Any help or pointers would be great...

    Thanks in advance.

    Monday, May 18, 2015 3:09 PM

Answers

  • Thanks for the response Paul but I had already worked that one out.

    In the end it is different as it uses claims based Auth - here is what I did to get it to work for me...

    SELECT     
    pub.MSP_WEB_SECURITY_GROUPS.WSEC_GRP_NAME, 
    pub.MSP_WEB_RESOURCES.RES_NAME
    FROM         
    pub.MSP_WEB_SECURITY_GROUP_MEMBERS
    INNER JOIN
    pub.MSP_WEB_SECURITY_CLAIMS ON pub.MSP_WEB_SECURITY_GROUP_MEMBERS.WRES_GUID = pub.MSP_WEB_SECURITY_CLAIMS.SECURITY_GUID
    INNER JOIN
    pub.MSP_WEB_RESOURCES ON pub.MSP_WEB_SECURITY_CLAIMS.ENCODED_CLAIM = pub.MSP_WEB_RESOURCES.WRES_ACCOUNT
    RIGHT OUTER JOIN
    pub.MSP_WEB_SECURITY_GROUPS ON 
    pub.MSP_WEB_SECURITY_GROUP_MEMBERS.WSEC_GRP_GUID = pub.MSP_WEB_SECURITY_GROUPS.WSEC_GRP_GUID
    Hope this helps anyone else who needs it!

    Tuesday, May 19, 2015 3:28 PM

All replies