Query to List PWA Groups with Resources

The following query gives you list of groups with users, their NT accounts, email address & some other details.

-- This Query give gives the list of groups with associated users. (by FM - faisalmasood.com)

select sg.Wsec_Grp_ID as GroupID, sg.Wsec_GRP_Name as GroupName, mr.Wres_ID,
mr.Res_name as ResourceName, mr.Wres_NT_Account as NTAccount, mr.Wres_email as Email,
mr.Wres_Use_NT_logon as UseWinAuthentication, mr.Wres_Is_Enabled as IsEnabled, mr.Wres_Can_Login as CanLogin,
mr.Wres_Last_Connect as LastConnect, mr.Wres_is_Manager as IsManager
from msp_web_security_groups sg
inner join msp_web_security_group_members sgm on sg.Wsec_grp_guid = sgm.Wsec_grp_guid
inner join msp_web_resources mr on sgm.Wres_GUID = mr.Wres_GUID
--where sg.wsec_grp_id = 4 AND sg.WSec_grp_name like 'Project Managers'
order by sg.wsec_grp_name, mr.res_name

(Contact your DBA / Project Admin to run this query)