An SQL Query for a specific executable that is NOT on a machine
Posted on 2011-09-09
I am new to sql queries - I have no problem finding something that IS on a machine, but today I was asked to find machines that do NOT have a specific executable.
In this case, I am only looking for "someprogram.exe" to not be on a machine, and I don't want to see all the programs that are not like "someprogram.exe" because that will list everything on the machines.
How would I write a query to look for something to not be on the machine.
Just to keep it easy - lets say everything is in one table so we don't need to join anything - I just need to know some basic syntax.