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

Advanced Scripting – Debugging and dumping all available variables in a script to a log

2017-03-28T01:55:24+01:00March 28th, 2017|

For those who have developed LabTech scripts before, especially complex ones, it's sometimes very difficult to debug scripts or even find the certain name of a variable you are looking for. Sometimes you will know the actual value from a script that you need, but not know the variable name. This is further complicated by all the variables not [...]

Diagnosing LabTech Report Center Scheduling E-mail/File Problems – an in-depth Analysis using Procmon, SQL, and Powershell

2017-03-01T09:34:58+00:00March 1st, 2017|

For a long time now, my LabTech has not been able to run scheduled reports. I've had a support case open since August 2016 for this issue. Independent to this, I've recently setup a LabTech Lab at home, a completely fresh install running LT 11 Patch 9, setup with exactly the same configuration of my live environment. I tested the [...]

Go to Top