Query to List PWA Groups with Resources

Query to List PWA Groups with Resources

Version 4.1, Modified: 09/03/2018

Applies To: Project Server 2007, 2010, 2013, 2016

The following query gives you list of groups with users, their NT accounts, email address & some other details in Project Web App. I’ve used the query to get list of all users that have Project Manager / Resource Manager access or part of similar custom groups. These can be often helpful in getting the list of users that might have MS Project Professional installed on their desktops for licensing counts.