Local Admin Group Members

[kevinoie]

Hi. I am trying to generate a report to find ALL user accounts and groups who have Local Admin rights on all pc's and servers on my domain.


I can find the report for Unathorised users but I need a report for all users and groups who have local Admin rights.

Any help would be greatly appreciated.

Thank you.

Kevin.

[Glenn_Gagne]

Hi,

It's an old post and very useful. But because I'm in a situation where we have multiple OS languages, the "local Admin group" is not always named "Administrators". Does something is possible with LanSweeper to use the "local Group GID" to ensute is working ?

[S_B]

Thanks a lot, works perfect.

[Diego_Tomazzoni]

Very useful report, tks a lot!

[kevinoie]

Thanks a million. Exactly what I need.

[Hemoco · Accepted solution]

You can use the following report to get all local administrators.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblUsersInGroup.Username,
tblUsersInGroup.Domainname,
tblUsersInGroup.Groupname
From tblAssets
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Where tblUsersInGroup.Groupname = 'administrators'
Order By tblAssets.AssetName