«

»

Выгрузка пользователей Project 2007/2013(членство в группах). SQL retrieve group memberships from sql database

Выгрузка пользователей Project Server (членство в группах). Retrieve group memberships from sql database

2013

use [Project Server Database]

SELECT WSG.WSEC_GRP_NAME AS [Group], R.RES_NAME AS Member

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 [Group], Member

2007

use [Project Server Database]

SELECT WSG.WSEC_GRP_NAME AS [Group], R.RES_NAME AS Member

FROM MSP_WEB_SECURITY_GROUPS AS WSG

INNER JOIN MSP_WEB_SECURITY_GROUP_MEMBERS AS WSGM ON WSG.WSEC_GRP_GUID = WSGM.WSEC_GRP_GUID

INNER JOIN MSP_RESOURCES AS R ON WSGM.WRES_GUID = R.RES_SECURITY_GUID

ORDERBY [Group], Member

Permanent link to this article: http://www.blogss.ru/retrieve_group_memberships_from_sql_database

Добавить комментарий

Your email address will not be published.