Specific local user not in local admin group => Result Device name

[S_B]

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 ?

[S_B]

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]

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]

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.