For a good while now I have been relatively cynical of the "100% Compliant" statistic that I see on certain servers in the Patch Manager and I have been considering how best to approach finding problems with patching that were not otherwise being highlighted. I designed this report to follow an important Automate mantra; trust, but verify. This report [...]
RAWSQL Help and Tutorial – A how to, plus an internal monitor example to Detect Hung Servers and run Custom SQL in LabTech
The internal monitor referenced in this post can be downloaded here: LT - Offline Servers Custom - Hung Server I've been meaning to do a blog on RAWSQL monitors for a while - so here it is! The initial request is here https://www.labtechgeek.com/topic/4012-internal-monitor-for-over-x-amount-of-failed-logins-in-a-time-period The first request there is attached as a RAWSQL Internal monitor. Extract the .SQL from this and [...]
[crayon-5eff35ef5908b228743774/] 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.
Diagnosing LabTech Report Center Scheduling E-mail/File Problems – an in-depth Analysis using Procmon, SQL, and Powershell
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 [...]
Another useful SQL snippet to post today, used to identify machines where commands are stuck executing. This usually is an indication of a problem with the LabTech service on the machine, but could also mean something more underlying is broken on the client. SELECT commands.computerid, v_computers.computer_name, v_computers.client_name, Count(*) AS NumOfCommands FROM commands LEFT JOIN v_computers ON commands.computerid = v_computers.computerid WHERE status = 2 GROUP BY computerid ORDER BY numofcommands DESC
The eventlog table, housed in the back-end database of LabTech is in most cases going to be one of your biggest tables. What most people don't realise is that a lot of the space used in there can often be down to a few machines who have issues that can be logging multiple times a second into the event [...]