
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-12-2019 02:55 PM
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 ?
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 ?
Labels:
- Labels:
-
Report Center
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2019 01:50 PM
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.
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2019 01:47 PM
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:
Once added you can add the following to your where clause:
And (tsysOS.OSname = 'Win 7' OR tsysOS.OSname = 'Win 10')

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2019 01:17 PM
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.
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.
