Find All Local Administrators on Your Network
Local admins account are often a security issue because of the access rights they have on a local computer. This allows both the user and any services or programs running in their security context from doing whatever they want. Making sure that there are no local admin accounts in use that you are unaware is therefore critical. To find all the local admin account that still reside in your network you can simply run the audit and get to work with removing them.
Local Administrator Account Name Query
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
