2 Mar 18

Why you should almost never need to run anything as Admin in Automate

2018-03-02T23:30:43+00:00March 2nd, 2018|

By far the biggest trap that people fall into when they start leveraging the capabilities of Automate scripting, commands and all other sorts of goodies, is they choose to run those features as Admin. There are a significant amount of functions that allow you to run as Admin. Most people try these functions and they don't work as they [...]

6 Feb 18

Free Report – Anti-Virus Health including Compliant Devices

2018-02-06T20:38:05+00:00February 6th, 2018|

This is one that I have been asked for for a while. I have designed the Compliant Assets section to look similar to the original At-Risk Assets design. This has been tested in Automate 11 and 12. You can download it here: Antivirus Health including Compliant Devices It looks like this, I hope you find it useful:

16 Jan 18

Spectre/Meltdown Vulnerability Detection – Free Detection Solution

2018-11-06T02:48:45+00:00January 16th, 2018|

I started working on this as soon as there was a reasonably easy way to detect vulnerable machines on Windows. It includes: A script that you run against agents, which sets EDFs and highlights numerous things (BIOS/Firmware update, notes, whether certain mitigations are enabled and whether you are secure) A Dataview that you can import to have a good [...]

16 Jan 18

Running programs/scripts as a logged in user in a LabTech/Automate Script

2018-11-06T02:41:36+00:00January 16th, 2018|

Two of the questions that we get asked often in the LabTech Geek Slack are usually phrased like this: I am trying to map a drive/delete a desktop icon/edit the registry for a user in a script and it is not working How do I run things on the user desktop? The reason number 1 doesn't work is because [...]

6 Dec 17

Remote Monitor – Use LabTech/ConnectWise Automate to monitor latency/response time on a network

2017-12-06T11:40:50+00:00December 6th, 2017|

Though Automate/LabTech has built-in tests for website latency and simple ping up/down checks, there is nothing in place for monitoring latency/response time on a network. This can be achieved by doing the following: Right click the agent you want to install the monitor on, Monitors > Add New Monitor Choose Yes to create using the Wizard Choose Monitor the results of an Executable [...]

10 Nov 17

Internal Monitor – RAWSQL – Machine’s running Office 2007 (V12) or Earlier

2017-11-10T22:14:58+00:00November 10th, 2017|

I thought this one of mine was worth sharing, especially helpful if you need a method of mass generating alerts/tickets/warnings for clients running Office 2007 or earlier. Internal Monitor - SOFTWARE - Office 2007 or Below Installed - Zipped SQL Download Install Instructions: Extract the .SQL file out of the zip download above In the LabTech CC, go to [...]

20 Oct 17

Report Center – DLL Error – There was an error loading the report data

2017-11-08T01:50:57+00:00October 20th, 2017|

Something that has plagued the Report Center for a while, tonight I got chance to sit down and have a look at what was causing the problem. If you have exported the repx files previously for this report, it may be a better idea to just import it instead of doing the below. This is meant for situations [...]

13 Oct 17

Remove a Probe from an Offline Agent

2017-10-13T10:53:40+01:00October 13th, 2017|

I see this question raised a lot - and there is a simple way to resolve it. On the agent run the script in Maintenance > Agent > Probe - Remove from an Offline Agent. That's all that is needed!

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

2018-09-24T23:51:53+01: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. [crayon-5df4a5287199e185519227/]  

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

Load More Posts