There are times when you want to know who the users are in a particular group. Depending on your level of privileges, there are various ways to get this information:
1. You can find out about it using the SQL Server Management Studio or Query Analyzer:
EXEC xp_logininfo ‘DOMAIN\group_name’,'members’
To run this, you will need to have a sysadmin or a public access in the master database with EXECUTE permission granted. For more information, see BOL – xp_logininfo
2. You can also do this using the command prompt:
cmd> net group “group_name” /domain
Will yield the same result as above.
Drill down a user by using the net user command:
cmd> net user user_name /domain
3. GUI: Administrative Tools> Active Directory Users and Computers
Right click on your domain and select Find. Type in the group name (without the domain) and click Find Now. Double click on the result. Select Members tab to see the list of users in that group.
