SCOM | I do stuff sometimes.

Ramblings about things.

Archives

Update: SCOM: October 2016 patch makes your Console crash


Awesome Microsoft, way to go with QA when you make your own core products crash… It seems that the bundled October patch for Windows Server 2008x and 2012x makes the SCOM Console crash when viewing different state views. The patches mentioned: Server 2008 – https://support.microsoft.com/en-us/kb/3192391 Server 2012 – https://support.microsoft.com/en-us/kb/3192392 After uninstalling theese in my environment, the Console…

Read More

SCOM: Get Subscriber in Subscription


This little thing will search through, and get all subscribers containing your searchword in any subscription you may have set up in SCOM. param( [String]$searchword ) $sub = Get-SCOMNotificationSubscription | select displayname,torecipients write-host “Searchword: “”$searchword”” exists in the following subscriptions:” foreach ($s in $sub){ $recipient = $s.torecipients.name if ($recipient -like “$searchword”){ write-host “”$s.displayname”” } }…

Read More

SCOM: Get Maintenance Mode History


I use this query whenever I need to investigate Maintenace Mode history for SCOM agents. USE OperationsManagerDW SELECT ManagedEntity.DisplayName, MaintenanceModeHistory.* FROM ManagedEntity WITH (NOLOCK) INNER JOIN MaintenanceMode ON ManagedEntity.ManagedEntityRowId = MaintenanceMode.ManagedEntityRowId INNER JOIN MaintenanceModeHistory ON MaintenanceMode.MaintenanceModeRowId = MaintenanceModeHistory.MaintenanceModeRowId where DisplayName Like ‘%SERVERNAME%’ order by ScheduledEndDateTime – F

Read More

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

Output displayname and IP address for SCOMagents


Got bored – wrote this little thing to output FQDN and IPaddress for all Windows and UnixLinux agents in my lab environment. Could be useful for some people maybe.   ipmo operationsmanager $nixservers = get-scomclass -name “Microsoft.Unix.Computer” | Get-SCOMMonitoringObject $winservers = Get-SCOMClass -name “Microsoft.Windows.Computer” | Get-SCOMMonitoringObject Write-host “—————————————————————–” write-host “——————– Unix Computers and IPs ———————“…

Read More

Monitor Active/Passive Clustered Services… in SCOM?


I was playing around in Powershell the other day, and made this little thingy to help me monitor clustered Windows Services in an Active/Passive Windows Cluster solution. The script checks if specific Windows Services are running or not, and determines which node is active in the cluster by using the get-wmiobject cmdlet. There are many…

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

SCOM: Alert Task – Copy alert to clipboard


In our daily line of work, we sometimes need to show server admins and system managers alerts related to their infrastructure. Have you ever tried to copy/paste the Alert Details for an alert? It looks like crap, and contains alot of information the server admins and system managers couldn’t care less about. To make this…

Read More

← OLDER POSTS

  • Archives