→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Kinoal
Engaged Sweeper
Hello Everybody,

I just have a little question about creating a report about all users in local Administrator group for all computers.Do you know a way to adapt this report to show all admin accounts? :

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblUsers.Name,
tsysOS.Image As icon
From tblAssets
Inner Join tblUsers On tblAssets.AssetID = tblUsers.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblUsers.SID Like '%-500' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
You can use the built-in report “Computer: Unauthorized Administrators” to list the information you are after. It can be found under Dashboard\Reports\All Reports. If you haven’t authorized any admins under Configuration\Website Management\User Pages, all members of the local administrators group are listed in this report.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
You can use the built-in report “Computer: Unauthorized Administrators” to list the information you are after. It can be found under Dashboard\Reports\All Reports. If you haven’t authorized any admins under Configuration\Website Management\User Pages, all members of the local administrators group are listed in this report.