October | 2015 | I do stuff sometimes.

Ramblings about things.

Monthly Archives: October 2015

Useful SQL queries for OpsMgr DB


Here are some of the SQL scripts I usually use in case of… whatever. Many of these must be credited to Kevin Holman Set ALL agents to Remotely Managable UPDATE MT_HealthService SET IsManuallyInstalled=0 WHERE IsManuallyInstalled=1 Get Agents not Remotely Managable select bme.DisplayName from MT_HealthService mths INNER JOIN BaseManagedEntity bme on bme.BaseManagedEntityId = mths.BaseManagedEntityId where IsManuallyInstalled…

Read More

SCOM: Command Channel Script


This little script is what I use in cooperation with the SCOM Command Channel to parse and send SCOM alerts to a logfile. The script will take the SCOM alert parameters and put them neatly in a .log file, one file for each alert I want. This, of course, is customizable – I just like…

Read More

Request Template Certificates using CertReq and Powershell


Installing SCOM agents on non-domain servers can be a real time-consuming affair, especially the Create template-request-export-import-certificates procedure. I decided to use my basic certificate and CertReq knowlegde to create this little script that helps me automate the whole thing. NOTE: This is meant for inspiration only. If will for the most part not work in…

Read More

  • Archives