Monitoring with PowerShell – Deploy the Microsoft Safety Scanner (MSERT)

2021-03-08T12:43:51+00:00March 8th, 2021|

After seeing that the MSERT tool by Microsoft (The Microsoft Safety Scanner) detected recent Exchange threats https://www.bleepingcomputer.com/news/security/microsofts-msert-tool-now-finds-web-shells-from-exchange-server-attacks/, I thought it would be prudent as a secondary measure to deploy the tool, scan, and make sure everything across our estate was clean. Although I didn't have that problem in my environment, I thought it acted as a good tool to [...]

Pulling data from a Microsoft SQL Server or any ODBC compatible data source from inside an Automate Script

2020-12-28T15:27:18+00:00January 6th, 2021|

Did you know that it was possible to poll databases / datasets outside of the Automate database? All that is needed is a System DSN (OBDC Connection) on the agent you wish to query from, and you can then reference that in the following script function:On the agent, open the ODBC Data Source Administrator and go in to the [...]

ConnectWise Automate Advanced Scripting – Understanding variables passed from a monitor to a script

2021-01-05T13:19:59+00:00January 5th, 2021|

Have you ever been in a position where you have wanted to put together a custom script that triggers when a monitor fails, but you have no idea what variables are passed in to the script from the monitor? It's not like you can debug through this behaviour either as you can't trigger a script as monitor in debug [...]

Restrict or prevent an Automate script running during certain time frames

2020-12-28T15:12:10+00:00January 4th, 2021|

Happy new year, everybody!Today I am sharing a cool trick that you can use inside the Automate Scripting Engine to prevent scripts from running if the current time falls between a window that you set. This example can be run on any agent. This can be useful in situations where you say don't want a piece of software to [...]

The Automate script search that most people don’t know about

2020-12-16T01:02:11+00:00December 16th, 2020|

If you've ever tried to search for an Automate script with a specific bit of text, or you've wanted to use a scripting function but you have not idea how it should be implemented then this blog post is for you!Finding a real-life example of how a script function is utilisedYou can perform these searches from literally any script [...]

Running an Automate Script without an Agent – How to use Scheduled Client Scripts

2020-09-16T21:50:44+01:00September 16th, 2020|

Good evening, campers!Before I get into today's post, if you're on LinkedIn I'd love to connect with you. Please feel free to add me, I'll be posting some content on there in the future! https://www.linkedin.com/in/gavin-stone-1938146/Ever been in a situation where you need to run an Automate script, but don't particularly want to run it against a specific agent? Maybe [...]

Why I think now is a good time to start phasing out RMM specific scripts

2020-07-28T19:56:21+01:00July 28th, 2020|

It is no secret that ConnectWise has had a tough time recently. When you combine sequential critical security vulnerabilities with a seemingly uncertain future for the Automate product, it's going to start worrying some people. As a Managing Partner of MSPGeek, I have what I feel is a distinct insight into the thought processes and decision making of many [...]

Scripting – Easily convert multiple Powershell variables into Automate Script Variables

2019-12-10T18:33:46+00:00February 20th, 2019|

This concept really helps when you want to get multiple, individual items outside of a Powershell script and into multiple Automate scripting variables without messing about running a script multiple times to get different outputs. Step 1 In the scripting engine add a script step that does an Execute Script > Powershell. Add the following script in Script to [...]

SOGU File Searcher – ConnectWise Automate Script

2018-10-03T23:23:46+01:00October 3rd, 2018|

Following the release today by the United States Computer Emergency Readiness Team (https://www.us-cert.gov/APTs-Targeting-IT-Service-Provider-Customers), one of the steps they recommend is to use tools to detect intrusions and identify compromised systems and that these tool reports on APT (advanced persistent threat) actors using Sogu (also called PlugX) to compromise MSP systems. NCCIC recommends that network defenders use these tools to help [...]

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

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

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

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

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

Go to Top