→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎09-17-2010 09:24 PM
Solved! Go to Solution.
‎09-17-2010 10:33 PM
Select Top (10000000) dbo.tblcomputers.ComputerUnique,
dbo.tblcomputers.Computername
From dbo.tblcomputers
Where dbo.tblcomputers.Computername Not In (Select tblusersingroup.Computername
From tblusersingroup
Where tblusersingroup.Groupname = 'administrators' And
tblusersingroup.Username = 'domain admins')
‎09-17-2010 11:04 PM
‎09-17-2010 10:33 PM
Select Top (10000000) dbo.tblcomputers.ComputerUnique,
dbo.tblcomputers.Computername
From dbo.tblcomputers
Where dbo.tblcomputers.Computername Not In (Select tblusersingroup.Computername
From tblusersingroup
Where tblusersingroup.Groupname = 'administrators' And
tblusersingroup.Username = 'domain admins')
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now