SCOM Effective Monitoring Configuration Report



Export-SCOMEffectiveMonitoringConfigurationReport

Available here: SCOMHelper PowerShell Module

Report contains these columns:

AlertPriority
AlertSeverity
ClassId
ClassName
Description
Enabled
EntityId
EntityName
GeneratesAlert
Index
Overridden
Overrides
Parameters
Path
WorkflowDisplayName
WorkflowId
WorkflowMPName
WorkflowName
WorkflowType


*Note: “Overrides” column does not include customizations settings for the standard overrideable parameters: AlertPriority, AlertSeverity, Enabled. However, the values shown in these columns are the actual effective values and are accurate.

Example 1: Single Windows Computer – CSV

Will create a complete/full report CSV file and also individual .CSV config report files for all objects hosted on the target Windows Computer. (includes Verbose output for your viewing pleasure)

# Example
$ComputerName = "DB01.CONTOSO.COM"
$objs = Get-SCOMClass -Name 'Microsoft.Windows.Computer' | Get-SCOMClassInstance  | Where-Object Name -match "$ComputerName"
$ExportPath = 'C:\Temp\EffectiveConfig\'
Export-SCOMEffectiveMonitoringConfigurationReport -MonitoringObject $objs -ExportCSVPath $ExportPath -IndividualFiles -SortBy AlertPriority -SortOrder Ascending -Verbose

Notice I used the switch (-IndividualFiles) for individual config files. Each file* represents an object that lives on the server and contains the workflow configuration specific to it. However, the largest file at the top of the list contains ALL configuration information; it is the full report.

Sample Reports:
EffectiveConfigReport_AD01_WindowsComputer_individualfiles.zip



Example 2 – Single Windows Computer – HTML

Will output a basic (default format) HTML report for the specified SQL instance only.
NOTE: The ‘fancy’ HTML report should only be used for instances with few hosted objects. This fancy report does not perform well with a high row count.

# Example
$ComputerName = "2016b.CONTOSO.COM"
$objs = Get-SCOMClass -Name 'Microsoft.Windows.Computer' | Get-SCOMClassInstance  | Where-Object Name -match "^$ComputerName`$"
$ExportPath = 'C:\Temp\EffectiveConfig\'
Export-SCOMEffectiveMonitoringConfigurationReport -MonitoringObject $objs -ExportHTMLPath $ExportPath 

Example report here



Example 3 – Single SQL Database – Fancy HTML

# Example
$Name = "OperationsManager"
$objs = Get-SCOMClass -Name 'Microsoft.SQLServer.2016.Database' | Get-SCOMClassInstance  | Where-Object Name -match "^$Name`$"
$ExportPath = 'C:\Temp\EffectiveConfig\'
Export-SCOMEffectiveMonitoringConfigurationReport -MonitoringObject $objs -ExportHTMLPath $ExportPath -HTMLFormat Fancy

Example report here

One Reply on “SCOM Effective Monitoring Configuration Report”

Leave a Reply

Your email address will not be published. Required fields are marked *