This search will find every computer that does not have Adobe Acrobat Reader DC, and does not have Foxit, and does not have Sumatra. It is a relatively complicated one, but the following works when you structure it like this:
This will bring back computer results that have both Adobe AND VLC installed. The key here is the double AND - if you are going to structure this like that make sure it looks exactly as above or it won't work!
[crayon-5e881111d97e2626931860/] That's how! This SQL query will bring you back a list containing all the groups a computer is a member of, including the SearchID that is joining them to said group.
Searching in LabTech (at least in the Legacy search) is a lot easier to do for anything that requires an Exclude, but this option is missing in the advanced search. You can still build the search in the advanced view, it just requires a bit of building work. Start off with a new search, click the and and choose to add group. Click [...]