The Automate script search that most people don’t know about

2021-09-29T00:03:14+01:00December 16th, 2020|

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 [...]

How do LabTech Searches, Groups and Computers tie together?

2021-11-03T22:10:07+00:00March 28th, 2017|

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 [...]

Go to Top