Jump to content
[[Template core/front/profile/profileHeader is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

Leapo last won the day on October 31 2018

Leapo had the most liked content!

Community Reputation

3 Neutral

My Information

  • Agent Count

Recent Profile Visitors

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

  1. 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.
  2. 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;
  3. 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.
  4. 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?
  5. 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...