
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-24-2011 05:21 PM
Hi
I'm trying to created a report to show all computers without a particular username in the Local Administrators group. I've spent ages trying to this and getting nowhere.
[edit] I can pull up a report of all the computers with the username in the group but even that triplicates each result.
Does anybody already have some SQL code I could just put into the report.
Thanks in advance
I'm trying to created a report to show all computers without a particular username in the Local Administrators group. I've spent ages trying to this and getting nowhere.

[edit] I can pull up a report of all the computers with the username in the group but even that triplicates each result.
Does anybody already have some SQL code I could just put into the report.
Thanks in advance
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-26-2011 11:25 AM
try this
Select tblcomputers.Computername, tblcomputers.ComputerUnique,
tblcomputers.Domain
From tblcomputers
Where tblcomputers.Computername Not In (Select tblUsersInGroup.Computername
From tblUsersInGroup
Where tblUsersInGroup.Groupname = 'administrators' And
tblUsersInGroup.Username = 'someuser')
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2024 09:38 AM
Hello @Graymontinfra due to the age of this post I recommend starting a new topic here https://community.lansweeper.com/t5/reports-analytics/bd-p/LansweeperReports

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-26-2011 11:25 AM
try this
Select tblcomputers.Computername, tblcomputers.ComputerUnique,
tblcomputers.Domain
From tblcomputers
Where tblcomputers.Computername Not In (Select tblUsersInGroup.Computername
From tblUsersInGroup
Where tblUsersInGroup.Groupname = 'administrators' And
tblUsersInGroup.Username = 'someuser')

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2024 10:38 PM
Is it possible to have that code but for the new Lansweeper version? Thanks
