none
Project Server 2013 SSRS reports by logged in user group RRS feed

  • Question

  • Hi All,

    We are using project server 2013. We have developed SSRS report. We need to display the projects based on the logged in user security group(e.g Project Manager, Administrator etc.) I tried with the below query got from a forums. But it is not working. Is there is any way to get the security group of the logged in user using SQL query.

    SELECT     MSP_WEB_SECURITY_GROUPS.WSEC_GRP_NAME, MSP_WEB_RESOURCES.RES_NAME
    FROM         MSP_WEB_SECURITY_GROUP_MEMBERS INNER JOIN
                          MSP_WEB_RESOURCES ON MSP_WEB_SECURITY_GROUP_MEMBERS.WRES_GUID = MSP_WEB_RESOURCES.WRES_GUID RIGHT OUTER JOIN
                          MSP_WEB_SECURITY_GROUPS ON 
                          MSP_WEB_SECURITY_GROUP_MEMBERS.WSEC_GRP_GUID = MSP_WEB_SECURITY_GROUPS.WSEC_GRP_GUID


    Thanks in advance, Taj


    • Edited by arun_2014 Wednesday, June 4, 2014 12:47 PM
    Wednesday, June 4, 2014 12:46 PM

All replies

  • Taj,

    The query above gives you a complete list of user groups and users. It does not filter by resource name/group.

    You can get the logged in user using the "USer Filter" webpart, on which the SSRS report is being displayed (assuming you are displaying it on a SharePoint page).  You will need to pass this as a parameter into your SSRS report.

    http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=214

    http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=91


    Prasanna Adavi,PMP,MCTS,MCITP,MCT TWitter: @prasannaadavi Blog: http://www.prasannaadavi.com

    Wednesday, June 4, 2014 12:56 PM
    Moderator
  • Hi Prasanna,

    Thanks for your response.  I think current user filter should work for me, but how can I bring the Project Server user groups to "SharePoint Profile Value"


    Thanks in advance, Taj


    • Edited by arun_2014 Thursday, June 5, 2014 7:01 AM
    Thursday, June 5, 2014 7:00 AM
  • Hi All,

    Is there is any way have the SQL query to get the security group where user belongs to.


    Thanks in advance, Taj


    • Edited by arun_2014 Saturday, June 7, 2014 7:49 PM
    Saturday, June 7, 2014 7:48 PM