This search will find every computer that does not have Adobe Acrobat Reader DC, and does not have Foxit, and does not have Sumatra. It is a relatively complicated one, but the following works when you structure it like this:
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 [...]
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 [...]
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!
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 [...]
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 [...]
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
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 [...]
This report is a lot less boring than the previous, and great if you have a Datto. To run this report you will need to be using the official Datto plugin that exists so the report can access the data needed. The report includes numerous bits on information and looks great if you're showing clients that you truly are [...]
Now this is a bit of a "boring" report, more of a "compliance ticker" and its usage is limited to the data that is available in LabTech (in the database this is the table h_computers). I mostly used this report to refine my use of parameters to see how easy it was to filter. I give the option as [...]
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 [...]
This will bring back computer results that have both Adobe AND VLC installed. The key here is the double AND - if you are going to structure this like that make sure it looks exactly as above or it won't work!
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
This may seem something that sounds a little odd, but when you have the requirement for this it makes perfect sense. This is designed for scripts that don't actually need to be run on an agent. Maybe you want to execute a piece of PowerShell code using a LabTech script, or maybe you want to perform SQL queries against [...]
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 [...]
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 [...]
