Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Deflect last won the day on December 21 2018

Deflect had the most liked content!

Community Reputation

11 Good

My Information

  • Location
  • Agent Count
    2000 - 3000 Agents


Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. @Automation Theory Great write-up! Now make a post about migrating from MySQL 5.7 to Percona MySQL 5.7 and setting up PMM for the Automate instance. 😉 Actually according to the docs it's the only other compatible listed MySQL database support mentions. I even pointed it out to them and it was still up after they removed mentions of MariaDB. Weird since that's Linux only and would need to be a split server unless you're running it through a docker container or something which sounds even more unsupported.
  2. @JAlbright904 This was likely SC Session Trigger -> Office 365 Connector Card (MessageCard NOT AdaptiveCard) to to a Custom Teams Incoming Webhook. @itinfserv What do you have for your session trigger? In exchange and to answer your question: Open Computer: labtech:open?computerid=1 NOTE: If the ID starts with 'N', then it will open a Network Device (e.g., labtech:open?computerid=N1). This also works if you change that to ClientID or LocationID. This has to be a link though, copy/pasting in to your URL bar won't open it if you're looking to test!
  3. We have the same issue on a few computers i've seen. (Not all of them!) I'd rather not reset their ComputerID and blow everything away just to resolve that issue.
  4. @nerenther Check back after patch 2019.9 is released. Around the beginning of next month. That should have what you're looking for!
  5. This looks awesome. I'm so glad I came across this since I had this as a task in Jira for something I'd need to do to help with reboot prompts. You're awesome for sharing this! 😀
  6. @bigdessert Any way to add the ability to add a custom header key/value? Example usage is to make an auth call and get a bearer/auth token from an API that requires all subsequent GET / POST requests to use that token with a custom name like "X-ExampleHeader-Name".
  7. @bigdessert Getting a load error on RMM+ for version: 1.0.8 for ScreenConnect version 19.0.23665.7058 I went from 6.9 to 19.0.2 last friday and updated all my extensions afterwards. c:\Program Files (x86)\ScreenConnect\App_Extensions\8e78224d-79db-4dbb-b62a-833276b46c6e\Service.ashx(45): error CS1061: 'System.Collections.Generic.IEnumerable<ScreenConnect.SessionEvent>' does not contain a definition for 'FirstOrDefault2' and no extension method 'FirstOrDefault2' accepting a first argument of type 'System.Collections.Generic.IEnumerable<ScreenConnect.SessionEvent>' could be found (are you missing a using directive or an assembly reference?) I checked for updates and it couldn't find any for RMM+ at least. I ended up uninstalling and it found version 1.0.14 on the extension gallery then. Just a heads up!
  8. Thank you sir 😀 Were you the one that was also working on the ITGlue addition for RMM+ Passwords?
  9. x 1000 - Even if this wasn't the case, we should all take this as a great opportunity to help develop a framework for easily reporting vulnerabilities and working with the appropriate resources. There used to be a location to report it on the old LabTech website. It's no longer accessible unfortunately.
  10. At some point in your career with LabTech you'll be forced to work directly with the database. Normally the go-to recommendation are Chris Taylor's docs at: http://labtechconsulting.com/LT-DB/index.html however that schema hadn't been updated since 2015 with many large and small changes over the years. Also comments had been truncated leaving many cut off mid sentence? I have two updated versions available. One is a downloadable chm file made in the same style as the official ConnectWise Manage data dictionary. I also have an online version that's nearly identical. I recommend the chm as it has a few notable advantages. The search in the chm file can do a full search across *everything* and . That includes the code for the trigger/view/procs, etc. Not only that but you can also pin to your favorites anything frequently used that persists. Both feature vector graphs to visually show relationships as well as the underlying code though! I also included all core LabTech plugins so it'd be the most complete reference doc. Everything is drillable so you can easily explore how different objects relate to each other. If you have a good writeup for any descriptions I can roll it into an updated release. Hopefully one day everything will be documented! View the code for functions, procedures, views Example viewing a trigger after clicking on one of our related dependencies. Pin frequently used Tables/Views to your favorites tab! I'll be updating them if anyone has any feedback or comments I can add in. Feel free to shoot me a message on here or on the LTG Slack "smeyer" Online: LabTech Data Dictionary Offline Docs: LabTech 2019.4.chm *New and improved* You may have to unblock the file after downloading! Older Releases: Online v12 P8 Data Dictionary
  11. Weeeeird! Good catch, but when I copy->paste your query into my editor it also complains about syntax. It says the ending single quote on the query is the problem. Delete it and type another single quote and it works fine. Heck, just copy->pasted my post I edited above to fix it and it does the same thing. Maybe some weird forum escaping of characters or sql injection protection?
  12. Some of the items from Joe's post I also do in my maintenance scripts. So you can Copy->Paste: Delete drives from the drives table where missing=1 DELETE FROM drives WHERE missing =1; Delete old remote drive monitors for missing drives DELETE agents FROM `agents` LEFT JOIN drives d USING (computerid) WHERE LEFT(agents.dataout, 1) NOT IN ( SELECT letter FROM `drives` WHERE computerid = d.computerid) AND agents.name LIKE 'Disk - %' Reset hotfixes that have been marked as pushed, but have not installed UPDATE hotfix SET pushed='0' WHERE installed=0 AND pushed=1 AND approved=1 He truncates the plugin_cw_infomessages, but I only delete the lowest severity since there is occasionally helpful data ... sometimes. DELETE FROM plugin_cw_infomessages WHERE plugin_cw_infomessages.`TimeOccurred` < DATE_ADD(NOW(), INTERVAL -1 DAY) AND plugin_cw_infomessages.Severity = 10
  13. Getting the same error as speakerbox occasionally along with this gem:
  • Create New...