If you've ever tried to search for an Automate script with a specific bit of text, or you've wanted to use a scripting function but you have not idea how it should be implemented then this blog post is for you! Finding a real-life example of how a script function is utilised You can perform these searches from literally [...]
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!
SELECT searches.*, computers.name, sensorchecks.name AS Test FROM searches LEFT JOIN computers ON computers.computerid = searches.computerid INNER JOIN sensorchecks ON searches.searchid = sensorchecks.sensid WHERE computers.name IS NOT NULL ORDER BY NAME ASC 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 [...]
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 [...]