2 of 2 people found this helpful
One potential problem is that if your server has software A, and not software B, that server would be returned. To know which is missing, you would need to add a column to your query column set to show the software name, and then add a qualifier to filter down that name to either software a or software b. Otherwise it's a bit hard to verify the results of the query.
The second oddity is your Computer.Computer Location. That's not a very reliable way of returning servers. Instead, I would use Computer.OS.Name LIKE Windows Server. That reduces the query to just 3 lines.
Below is an example using WinPcap 4.1.3 and Windows Driver Kit as software A and B. It's a bit stretched to show the qualifier information.
And the results:
In this case I have one server that has neither of those programs, one that has the Driver Kit but not WinPcap, and 3 that have WinPcap but not the Driver Kit.
This document has a really good breakdown of how our queries work and why you may not get the results you want:
This ended up doing the trick for me. I had not used a Qualifier before in the Column Sets before.
Thank you for your time!