Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Leapo last won the day on April 2 2020

Leapo had the most liked content!

Community Reputation

5 Neutral

My Information

  • Agent Count

Recent Profile Visitors

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

  1. Two more we added recently for keeping Network Devices clean: # Auto-purge network devices that have not been seen in more than 30 days DELETE FROM networkdevices WHERE LastContact < DATE_ADD(NOW(),INTERVAL -30 DAY); # Auto-purge duplicate network devices DELETE FROM networkdevices WHERE networkdevices.DeviceID IN ( SELECT DISTINCT DeviceID FROM ( SELECT t1.* FROM networkdevices AS t1 JOIN (SELECT LocationID, IPAddress FROM networkdevices GROUP BY LocationID, IPAddress HAVING count(*) > 1) AS t2 ON t1.LocationI
  2. Our first attempt to upgrade from 2019.12 to 2020.2 resulted in the installer completely hosing our server, to the point that we had to restore from backup. It would appear that the installer does not handle file replacements in the "C:\inetpub\wwwroot" folder safely, and is unable to roll back the changes if an issue is encountered while replacing these files. In our case, the installer deleted all files in "C:\inetpub\wwwroot\cwa", then encountered a locked file that it was unable to replace. This triggered an installation failure and automatic rollback (the user is not given the o
  3. I was unable to log into the control center with any user account after installing 2019.3. Had to reboot the Automate server and run the patch a second time before everything started working right again.
  4. Here's a selection from my daily SQL maintenance script: # Automatically classify drives as SSDs UPDATE drives SET SSD='1' WHERE ( Model LIKE '%SSD%' OR Model LIKE '%NVMe%' OR Model LIKE 'SAMSUNG MZ%' OR Model LIKE 'SAMSUN MZ%' OR Model LIKE 'SanDisk SD%' OR Model LIKE 'SK hynix%' OR Model LIKE '%LITEONIT LMT-256%' OR Model LIKE '%LITEONIT LCS-128%' OR Model LIKE '%LITEON LCH-128%' OR Model LIKE '%LITEON L8H-256%' OR Model LIKE 'MTFDDAK%' OR Model LIKE 'PLEXTOR PX%' OR Model LIKE '%Optane%' OR Model LIKE 'SD Card' OR Model LIKE '%SD-CARD%' OR
  5. I ran into the same issue with removing the "HomeBusinessRetail" SKU on Office 2013 and 2016, as well. I've informed @kelliott of the issue via slack.
  6. It's already pretty easy to send messages to Teams from Automate and Manage via the Rest API or email (every channel in Teams has an email address). What does this plugin add over the built-in messaging features?
  7. I actually made a script to do exactly this! It's primarily just some PowerShell, deployed via group policy. Here's the XML, ready for import: This is the actual meat of what's going on. Also note, this script will attempt to install the components it needs to run, but was intended to be run against the target network's Domain Controller. # Install required Windows features: # * Import the Server Manager PowerShell module # * Install Active Directory PowerShell Module # * Install Group Policy Management Components (GPMC) Import-Module ServerManager Add-WindowsFeature RSAT-AD-PowerShell A
  • Create New...