Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 09/21/20 in all areas

  1. Got this little snippet at one time from CWSupport, maybe want to run this periodically to clean things up /*Patching Cleanups*/ /*Eliminate extra policy approvals from system if the policy is gone*/ DELETE FROM `patchapprovalsettings` WHERE ApprovalPolicyID NOT IN (SELECT ApprovalPolicyID FROM `patchgroupapprovalpolicies`); /*Clean out Hotfix Table if the computer no longer exist*/ DELETE FROM `hotfix` WHERE computerid NOT IN (SELECT computerid FROM computers); /*S&H patch numbers that do not match the agents Issue: If a missing patch is superseeded before S&H can see it ha
    2 points
  2. Another one from the Slack files, this one courtesy of @MartynKeigher Appends a '*' to the name of all searches being used by a group to join agents or network devices: UPDATE sensorchecks SET `name` = LEFT(`name`,LENGTH(`name`)-1) WHERE `Name` LIKE '%*'; UPDATE sensorchecks SET `name` = CONCAT(`sensorchecks`.`name`, '*') WHERE sensid IN (SELECT autojoinscript FROM mastergroups) AND `name` NOT LIKE '%*'; UPDATE sensorchecks SET `name` = CONCAT(`sensorchecks`.`name`, '*') WHERE sensid IN (SELECT networkjoin FROM mastergroups) AND `name` NOT LIKE '%*'; UPDATE sensorchecks SET `name` =
    1 point
  3. Dell: I've got Dell Command Configure automatically configuring the BIOS to turn on all Dell desktop workstations at 11PM. I've been using this for a few years to help with stubborn users that think they should power off their machines at night. Helps with after-hours maintenance tasks. The Automate side of it is pretty simple, search that finds Dell workstations that aren't portable tied to an auto-join group. Then a check to see if the software is already installed, run the install if it's not, then regardless if it's installed I run the command line version of the software
    1 point
×
×
  • Create New...