→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
S_B
Engaged Sweeper II
I really really need your help please.
I have looked into every similar thread here in the forum, but non of those solutions work for me 😞
I am looking for an very simple report, unfortunately I do not have the knowledge for it.

I need a report which reports the following to me:

Every Windows 7 and Windows 10 device which does not have the local user (called "GC") in the local admin group.
As result I only need the device name, so I can deploy a script on this device, thats it.

Please can someone help me ?
3 REPLIES 3
S_B
Engaged Sweeper II
Thank you, this worked fine.
And how do I get it work that only domain devices are shown ?
I tried with this:
And tblAssets.Domain Not Like 'WORKGROUP'

But this does not work at all.
Even if I pick this under Select Top 1000000

Many thanks.
Esben_D
Lansweeper Employee
Lansweeper Employee
To filter for W7 and W10 you'll need to add the table tsysOS to your report.

Once added you can add the following to your where clause:

And (tsysOS.OSname = 'Win 7' OR tsysOS.OSname = 'Win 10')
S_B
Engaged Sweeper II
This is my code so far:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName
From tblUsers
Join tblAssets On tblAssets.AssetID = tblUsers.AssetID
Where tblUsers.Name <> 'GC'
Group By tblAssets.AssetID,
tblAssets.AssetName


I just dont know how I can filter after WIn 7 and Win 10 and no workgroup devices.