So here is the problem
I am building a query that will show me all systems that have vulnerabilities but I want to exclude microsoft definitions. When I build my query I am using the following criteria for vulnerabilities in general:
Security and Patch Definitions.Detected = 1
That returns all detected vulnerabilities per system and it works fine
I then add the following criteria:
*AND Computer.Security and Patch Definitions.Patch Required Not Like kb*
With that addition I get "Query has no results "
If I change that to read the following:
*AND Computer.Security and Patch Definitions.Patch Required Like kb*
I get all systems that have any vulnerabilities that have the letters kb in the executable name.
So why does the LIKE but not the NOT LIKE work?
ALL QUERY ENTRIES IN THIS POST ARE PSUEDO NOT EXTACT QUERY WHERE STRINGS