jdav

Hi folks,

I am trying to run a Report to find machines not running a specific piece of software. The application has a specific service in Windows as well as an executable which displays in the "Aex SW Audit Software" table. I have tried running my query against the "Aex AC NT Services" table, it will show me the machines that are running the service but when I reverse the query (not equal to) , it won't display machines that are not running the service. I think it has to do with the keys in the table, a primary key is assigned to each service running on a machine.

Has anyone any suggestion how I could write a query to return machines that are not running a particular piece of software....thanks in advance

Regards,