About gavsto

This author has not yet filled in any details.
So far gavsto has created 58 blog entries.

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

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

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

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

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

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

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

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

How many commands do you have stuck executing in LabTech? It’s worth checking!

2016-11-01T01:33:32+00:00November 1st, 2016|

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

Putting Labtech on a diet – working out your “noisiest” agents for Event logs

2017-06-19T02:52:54+01:00October 11th, 2016|

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

In-depth review of Zendesk and its potential usage at an MSP

2016-09-04T15:55:16+01:00September 4th, 2016|

We're currently going through a period in our MSP where we are looking to implement better systems. We're using a lot of systems that though work, are out dated and are slowing our ability to grow properly and provide the level of customer service that we know we can. One of those areas is ticketing. I've posted a lot [...]

Labtech Script – Installing or Updating Dell OpenManage Server Administrator (OMSA) 8.3.0

2016-08-15T22:52:42+01:00August 15th, 2016|

    I've been sharing this script with a few of the people on the LabtechGeek slack (if you are not already a member it is a great community and you can sign up here http://bit.ly/2beGZoW) This particular script came about due to a need to upgrade mass amounts of OpenManage on servers at once. The script does a number [...]

Load More Posts