Download: This function is included in the SCOMHelper PowerShell Module.

Export-SCOMEffectiveMonitoringConfigurationReport

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

Download: This function is included in the SCOMHelper PowerShell Module.