Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Leapo last won the day on April 2

Leapo had the most liked content!

Community Reputation

4 Neutral

My Information

  • Agent Count

Recent Profile Visitors

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

  1. 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 option of attempting to fix the issue, it just rolls back on its own), but DID NOT restore any of the files deleted from the "C:\inetpub\wwwroot\cwa" folder. This resulted in Automate being basically non-functional, with all logins failing.
  2. 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.
  3. 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 Model LIKE '%SDXC Card%' OR Model LIKE '%Flash Drive%' OR Model LIKE '%Flash Disk%' OR Model LIKE '%Flash Memory%' OR Model LIKE 'hp v150w USB Device' OR Model LIKE 'SanDisk Cruzer%' OR Model LIKE 'SanDisk U3 Cruzer%' OR Model LIKE '%USB 2.0 FD%' OR Model LIKE '%Card Reader%' OR Model LIKE '%Card Reader%' ) AND SSD <> '1'; UPDATE drives SET INTERNAL='1' WHERE ( Model LIKE 'SAMSUN MZ%' OR VolumeName LIKE 'Windows' ) AND INTERNAL <> '1'; UPDATE drives SET INTERNAL='0' WHERE ( VolumeName LIKE 'HP_TOOLS' OR VolumeName LIKE 'HP_RECOVERY' OR Model LIKE '%USB%' OR SmartStatus LIKE 'USB%' ) AND INTERNAL <> '0'; # Drop drives marked as "missing" from the database. DELETE FROM drives WHERE missing=1; # Reset hotfix status and re-allow push UPDATE hotfix SET pushed='0' WHERE installed=0 AND pushed=1 AND approved=2; # Cleanup h_scripts table DELETE FROM `h_scripts` WHERE HistoryDate < DATE_SUB(NOW(), INTERVAL ( SELECT VALUE FROM properties WHERE NAME = 'RetentionHistoryScriptLogs') DAY); OPTIMIZE TABLE h_scripts; # Delete all ticket data older than 30 days DELETE FROM tickets WHERE updateDate < NOW() - INTERVAL 30 DAY; OPTIMIZE TABLE tickets; DELETE FROM ticketdata WHERE ticketid NOT IN (SELECT ticketid FROM tickets); OPTIMIZE TABLE ticketdata;
  4. 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.
  5. 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?
  6. 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 Add-WindowsFeature GPMC # Import modules: # * Active Directory # * Group Policy Import-Module ActiveDirectory Import-Module GroupPolicy # Set Variables: # * Active Directory Distinguished Name # * Group Policy Name $Var_AD_DN = Get-ADDomain | select -ExpandProperty DistinguishedName $Str_GP_Name = "LT - Disable Windows Defender" # Create a new group policy: # * Create the object # * Set values within the object # * Link object to domain root New-GPO -Name $Str_GP_Name | Set-GPRegistryValue -Key "HKLM\Software\Policies\Microsoft\windows defender" -ValueName 'DisableAntiSpyware' -Type DWORD -Value 1 | New-GPLink -target $Var_AD_DN Group Policy - Disable Windows Defender.rar
  • Create New...