cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cheche
Champion Sweeper
How can I know what computers have not installed "my service"?
2 REPLIES 2
cheche
Champion Sweeper
Works fine. Thanks!
Hemoco
Lansweeper Alumni
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblservices.Computername
From tblservices Where tblservices.Name = 'my service')