Local administrator

[laurentiune]

Hello,
I would like to have a report with local administrators group. Domain members of the "administrators" group from each computer and option to exclude built in users like "administrator" or other custom users.

Thank you.

[Hemoco · Accepted solution]

You can use the following report. You need to change the red word with the name of the user that you want to exclude from the report.


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblUsersInGroup.Username,
tblUsersInGroup.Domainname,
tblUsersInGroup.Groupname
From tblAssets
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Inner Join tblADusers On tblUsersInGroup.Username = tblADusers.Username And
tblUsersInGroup.Domainname = tblADusers.Userdomain
Where tblUsersInGroup.Username <> 'name user' And tblUsersInGroup.Groupname =
'administrators'
Order By tblAssets.AssetName