Reporrt : All Admin Accounts for All computers

[Kinoal]

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

[Hemoco · Accepted solution]

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.