List members of all the groups

[Peggy Cornett]

MS Project 2003 (11.2.2005.1801.15) SP2 Project Server 2003 SP2

How can one get a list of all the members that make up each group? a list
of categories would be nice too.
Thanks,
Peggy Cornett

 

[John Cello]

Peggy:

Try this SQL statement:
SELECT dbo_MSP_WEB_RESOURCES.RES_NAME,
dbo_MSP_WEB_SECURITY_GROUPS.WSEC_GRP_NAME
FROM (dbo_MSP_WEB_RESOURCES INNER JOIN dbo_MSP_WEB_SECURITY_GROUP_MEMBERS ON
dbo_MSP_WEB_RESOURCES.WRES_GUID =
dbo_MSP_WEB_SECURITY_GROUP_MEMBERS.WRES_GUID) INNER JOIN
dbo_MSP_WEB_SECURITY_GROUPS ON
dbo_MSP_WEB_SECURITY_GROUP_MEMBERS.WSEC_GRP_GUID =
dbo_MSP_WEB_SECURITY_GROUPS.WSEC_GRP_GUID
GROUP BY dbo_MSP_WEB_RESOURCES.RES_NAME,
dbo_MSP_WEB_SECURITY_GROUPS.WSEC_GRP_NAME
ORDER BY dbo_MSP_WEB_RESOURCES.RES_NAME;

 

[Peggy Cornett]

Wonderful, worked great. Thanks

Peggy:

Try this SQL statement:
SELECT dbo_MSP_WEB_RESOURCES.RES_NAME,
dbo_MSP_WEB_SECURITY_GROUPS.WSEC_GRP_NAME
FROM (dbo_MSP_WEB_RESOURCES INNER JOIN dbo_MSP_WEB_SECURITY_GROUP_MEMBERS ON
dbo_MSP_WEB_RESOURCES.WRES_GUID =
dbo_MSP_WEB_SECURITY_GROUP_MEMBERS.WRES_GUID) INNER JOIN
dbo_MSP_WEB_SECURITY_GROUPS ON
dbo_MSP_WEB_SECURITY_GROUP_MEMBERS.WSEC_GRP_GUID =
dbo_MSP_WEB_SECURITY_GROUPS.WSEC_GRP_GUID
GROUP BY dbo_MSP_WEB_RESOURCES.RES_NAME,
dbo_MSP_WEB_SECURITY_GROUPS.WSEC_GRP_NAME
ORDER BY dbo_MSP_WEB_RESOURCES.RES_NAME;

--
John Cello
John Cello Consulting
Helping organizations hire, develop, and retain their best employees.
www.johncelloconsulting.com