OpsMgr | I do stuff sometimes.

Ramblings about things.

Archives

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

Awesome SCOM 2012 tools!


Here’s a link to some awesome SCOM tools that we use often for our SCOM 2012 environment. Thanks to Daniele for these new versions (SCOM 2012 compatible). – MPViewer 2.3 (View sealed and unsealed Management Packs, also has a very useful export-as-unsealed function). – Proxy Settings 1.2 (Select groups or multiple agents and enabledisable Proxysettings)…

Read More

Using Operations Manager Powershell CMDlets


Open Powershell and import the Operations Manager module with the following command: Import-Module –Name OperationsManager – F

Read More

  • Archives