Local Admin Users on all the computers with OU and user name

[udaykumar]

Hello Team,

Can you please provide me a report so that I can find out all the local admin users on all the computers on the network.

The report should include the assetname, local admin user name, IP address and the OU the user is in.

Thanks and Regards,
Uday

[Bruce_B · Accepted solution]

The report below lists all AD users that are part of the local administrator group, per asset.The report includes the asset IP address and the OU the account is in.

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