Get Resource Group Name Data Project Server 2013

Get Resource Group Name Project Server 2013:-

A project has multiple resources and here I am finding a resource group name.Each resource in project server has the own group and a group has own permissions define by admin.So there is two way to getĀ Resource Group Name first is using Project server Interface and second is SQL query. Here I am gettingĀ Resource Group Name by SQL query:-

SELECT WSG.WSEC_GRP_NAME AS [GroupName], R.RES_NAME AS [ResourceName], R.WRES_ACCOUNT AS [ResourceAccount]
FROM pub.MSP_WEB_SECURITY_GROUPS AS WSG
INNER JOIN pub.MSP_WEB_SECURITY_GROUP_MEMBERS AS WSGM ON WSG.WSEC_GRP_GUID = WSGM.WSEC_GRP_GUID
inner join pub.MSP_WEB_SECURITY_CLAIMS AS WSC on WSC.SECURITY_GUID=wsgm.wres_guid
INNER JOIN pub.MSP_RESOURCES AS R ON WSC.ENCODED_CLAIM = R.WRES_ACCOUNT
ORDER BY [GroupName], [ResourceName]

Get Resource Group Name Project Server 2013


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

error: Content is protected !!