cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kdunnett
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Andy_Sismey
Champion Sweeper III
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


View solution in original post

2 REPLIES 2
Andy_Sismey
Champion Sweeper III
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


This worked great, thanks!