|
Hi,
In general, you get the Guids of the computers that do have the software, then exclude them from the main query. Something like this:
Select _ResourceGuid
From Inv_Aex_AC_NT_Services
Where _ResourceGuid Not In (
Select _ResourceGuid
From Inv_Aex_AC_NT_Services
Where [Name] = 'your service'
)
Dan
|