This rule discovers a Local Alert Collection for a MSSQL 2017 on Windows Always On. This object is used to collect module errors and warnings from event log of SCOM agents that monitor Local SQL Server 2017 DB Engine instances.
This rule discovers a Local Alert Collection for a MSSQL 2017 on Windows Always On. This object is used to collect module errors and warnings from event log of SCOM agents that monitor Local SQL Server 2017 DB Engine instances.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Interval (seconds) | The recurring interval of time in seconds in which to run the workflow. | 14400 |
Synchronization Time | Synchronization Time |
|
Timeout (seconds) | Specifies the time the workflow is allowed to run before being closed and marked as failed. | 300 |
Target | Microsoft.SQLServer.2017.Windows.LocalDiscoverySeed |
Enabled | True |
Frequency | 14400 |
Remotable | False |
Discovered Classes and their attribuets: |
---|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2017.Windows.DataSource.LocalAlertCollectionDiscovery | Default |
<Discovery ID="Microsoft.SQLServer.2017.AlwaysOn.Windows.LocalAlertCollectionDiscovery" Enabled="true" Target="SQL2017WD!Microsoft.SQLServer.2017.Windows.LocalDiscoverySeed" ConfirmDelivery="false" Remotable="true" Priority="Normal">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitoringPoolAlertCollection"/>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="SQL2017WD!Microsoft.SQLServer.2017.Windows.DataSource.LocalAlertCollectionDiscovery">
<PrincipalName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</PrincipalName>
<DisplayName>Microsoft SQL Server 2017 on Windows Always On Local Alert Collection</DisplayName>
<MonitoringPoolClassId>$MPElement[Name='Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitoringPoolAlertCollection']$</MonitoringPoolClassId>
<IntervalSeconds>14400</IntervalSeconds>
<TimeoutSeconds>300</TimeoutSeconds>
<SyncTime/>
</DataSource>
</Discovery>