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 [...]
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 [...]
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 [...]
Searching in LabTech (at least in the Legacy search) is a lot easier to do for anything that requires an Exclude, but this option is missing in the advanced search. You can still build the search in the advanced view, it just requires a bit of building work. Start off with a new search, click the and and choose to add group. Click [...]
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 [...]
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
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 [...]
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 [...]
This doozy was issued in June following MS16-072. If you've had any user based GPOs just simply stop working in the past 2 months, it is likely that this is the culprit. Before this update, when a machine was processing its group policy, it used the user context to read the GPO on the DC. This update intentionally made [...]
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 [...]
I spent a very difficult few days figuring out the Labtech report center about a week ago, with not much documentation or usage cases around with it being relatively new I decided to dive in to see what I could do. I'm going to go through how to do this from scratch so as to hopefully help people trying to [...]
