13 Sep 17

Free Report – Patches installed in the last 30 days on all agents

2017-11-08T02:34:19+00:00September 13th, 2017|

This report was requested in the LTG forums and I can definitely see the benefit in it. The report will display any hotfix that has a finished date in the last 30 days. The report should not ignore empty agents, meaning that if you have an agent in this report and it is blank it means it hasn't done [...]

6 Sep 17

RAWSQL Help and Tutorial – A how to, plus an internal monitor example to Detect Hung Servers and run Custom SQL in LabTech

2021-11-03T22:08:32+00:00September 6th, 2017|

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

19 Jul 17

Adding a LabTech/CWA Role Definition for Bitlocker

2017-07-19T00:26:07+01:00July 19th, 2017|

A task for this morning that I thought I'd share the outcome to! I like having things in roles, it makes detecting them and scripting with them a lot easier. {%@manage-bde -status@%} Protection Status:[ \t]+Protection On  

29 Jun 17

Computer Audit with Installed Software Report

2017-11-08T02:36:25+00:00June 29th, 2017|

This report was requested on LabTech Geek's Slack. It displays a detailed overview of a computer, with details about the computer's identification, hardware information, latest performance, service history, software summary, overall drive information, network information, and software. I hope you enjoy. Now before you download this, the report is provided free of charge for your use at your own risk. I [...]

20 Jun 17

Report – Remote Access Audit grouped by User

2017-11-08T23:46:33+00:00June 20th, 2017|

This was something that was requested in the LabTech Geek Slack. I have put together the basic data structure, it will need to be "prettified" but it's a good starting point with the data, relationships and bands built for you already. Please ensure you manually verify this, it is provided as is and untested. Audit Remote Access - Group [...]

24 May 17

Remove return characters \r\n from ConnectWise Automate/LabTech Variables

2017-05-25T14:47:51+01:00May 24th, 2017|

A simple method when these are plaguing your script. It hit me again to day in the form of a script that wasn't doing what I expected, it wasn't until I looked at the output in a multi-line view did I see it was throwing in a return character in the middle of a command. You can fix it [...]

12 May 17

LabTech System Variables not working following a server migration

2017-05-12T22:46:36+01:00May 12th, 2017|

I saw someone post this resolution in the LabTech Geek Slack and thought it was worth posting! This occurs because triggers that are in the SQL database sometimes don't get transferred across, these "trigger" on each add or update of a row and add variables like LTRUNBYUSER. The resolution: -Stop IIS -Stop LabTech Database Agent service -Open SQLYog (from [...]

20 Apr 17

Patch Compliance Report – Including Compliant Devices

2018-06-28T23:45:55+01:00April 20th, 2017|

UPDATE 28th June: New report released to fix changes recently made to views and the template. Please re-download and re-publish. I have seen this requested in numerous places, and ConnectWise asked people to put in a feature request so I just decided to make one and release it. I have modified the current report to include a new section [...]

28 Mar 17

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

28 Mar 17

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

1 Mar 17

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

26 Feb 17

Software Install/Uninstall Report; comply with PCI-DSS and other well known standards

2019-11-30T21:27:19+00:00February 26th, 2017|

As I'm sure people who are working in the MSP/IT Sectors will agree, there are a lot more compliance requirements nowadays. A requirement I have seen a lot in most security standards is a process to review and record software installed/uninstalled on a machine - this report helps with that. The report uses data stored in LabTech to pull out [...]

26 Feb 17

Report Center – Patching Compliance Report not running

2017-02-26T17:02:40+00:00February 26th, 2017|

This has happened to a few people. If you are running the report and it is empty, it's highly likely that your patch calculations are not running daily. There are two ways to get these running: Go into Help > Server Status and click here: Note, if you hover over this it will tell you the last time it [...]

2 Feb 17

Mini Powershell Project – Extract individual pricing information for Action Pack from all Language Codes

2017-02-02T02:15:14+00:00February 2nd, 2017|

After reading a post on Reddit about there being different prices for the Action Pack for different languages, I decided to whip up a Powershell script that looped through all the language identifiers and extracted the bit of text I needed from each page. It's probably possible to extract the currency, but given different languages etc I didn't think [...]

20 Jan 17

LabTech Advanced Search – Finding computer’s that DON’T have a particular piece of software

2017-01-20T22:19:14+00:00January 20th, 2017|

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

29 Nov 16

Problems with permissions and creating a custom view for reporting

2017-03-28T02:04:59+01:00November 29th, 2016|

If you've created a custom view that you are using for the report centre and it is not working on the report, throwing errors like: "Error loading report data" or "Error loading datasource" or maybe any error relating to permissions, then you should make sure that the name of your custom view is prefixed with a v_ otherwise you [...]

Go to Top