→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kevinoie
Engaged Sweeper III
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

5 REPLIES 5
Glenn_Gagne
Engaged Sweeper III
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
Engaged Sweeper II
Thanks a lot, works perfect.
Diego_Tomazzoni
Engaged Sweeper III
Very useful report, tks a lot!
kevinoie
Engaged Sweeper III
Thanks a million. Exactly what I need.
Hemoco
Lansweeper Alumni
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