cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
udaykumar
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Bruce_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Bruce_B
Lansweeper Alumni
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