November | 2015 | I do stuff sometimes.

Ramblings about things.

Monthly Archives: November 2015

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

  • Archives