List of local group members

[Pollak]

Is there an option to view the local computer group memebers (e.g. members of Power Users group)? I would like to see a list like the Unauthorized Administrators.

Please advise,
Niles

[zuldan]

Works perfectly! Thank you very much.

[Hemoco · Accepted solution]

This information is stored in tblUsersInGroup.

Basic report for a user overview:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblUsersInGroup.Groupname, tblUsersInGroup.Username,
tblUsersInGroup.Admingroup
From tblComputers Inner Join
tblUsersInGroup On tblComputers.Computername = tblUsersInGroup.Computername
Order By tblComputers.Computername, tblUsersInGroup.Groupname

[zuldan]

I would love to know how to do this as well.

We have helpdesk giving some people local Administrator rights to workstations (naughty!).

It would be great to know which users have local admin rights on which workstations.