local admin users of a specific device

[kdunnett]

Hi there,

Is there a way to create a report that shows all the local admin accounts on one or all win 10 devices?

I can get to it manually by clicking on a device name--> Config tab--> User info tab--> Users in Groups

Thanks

Kirk

[Andy_Sismey · Accepted solution]

Hi Would something like this do, List all the members of the Administrator group by Asset :-

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblUsersInGroup.Username,
  tblUsersInGroup.Domainname,
  tblUsersInGroup.Groupname,
  tsysOS.OSname
From tblAssets
  Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblUsersInGroup.Groupname = 'administrators' And
  tsysOS.OSname Like '%Win 10%'
Order By tblAssets.AssetName

[kdunnett]

This worked great, thanks!