LabTech Plugin – SQL Query Analyzer

   Lets Query SQLsql_query-128

 

 

 

So you think your a SQL ninja? Well here is your sword!

The new SQL Query Analyzer for LabTech allows you to run SQL queries against the LabTech database directly from your LabTech control center consoles. This allows LabTech Cloud MSPs to directly query their SQL instances without the need for SQLYog or direct access to the database.

 

!!!Warning!!!
The Surgeon General has issues a warning that using this tool could cause major loss of data if not used by skilled SQL admins. Please be careful when using this tool.

Capture

 

 

 

Now Available Version 1.0.1 

download

 

 

 

 

 

 

LabTech Scripts – Cryptolocker probe script finds infections fast

 

 

cryptolocker-680x400

Catch Cryptolocker in the act

We have created a script for LabTech that you can schedule against any system to scan for possible Cryptolocker Decrypt Files, a sure sign that you been infected.

 

The script can be scheduled against all agents and if an agent is a Mac or Linux it will skip it, The probe will scan each drive letter found and then review that scan to see if it has found any files. Once it finds a file it will email an address but you can easily have it create a ticket or even set an alarm state.

 

When executing probe against a system you can monitor the Scripts Tab for the progress of the probe.

Capture

As the image above shows, a scan takes just a minute to complete. The C drive scan started at 1:08:34 and ended at 1:09:51, the scan took 1 minute and 17 seconds to scan 80GB hard drive.

 

Version 1.0.1 download

 

 

 

download

 

 

 

 

 

Enjoy  Cubert