Availability Group Database Security State (rollup)

Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityDbToAvailabilityGroupSecurity (DependencyMonitor)

This monitor rolls up security state of all availability databases to the availability group.

Knowledge Base article:

Summary

This monitor rolls up security state of all availbility databases to the availability group. .

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Generates Alerts

Defines whether the workflow generates an Alert.

No

Element properties:

TargetMicrosoft.SQLServer.Core.AvailabilityGroup
Parent MonitorSystem.Health.SecurityState
AlgorithmWorstOf
Source MonitorSystem.Health.SecurityState
RelationshipMicrosoft.SQLServer.Core.AvailabilityGroupHostsAvailabilityDatabase
CategorySecurityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityDbToAvailabilityGroupSecurity" Accessibility="Public" Enabled="true" Target="Microsoft.SQLServer.Core.AvailabilityGroup" ParentMonitorID="Health!System.Health.SecurityState" Remotable="true" Priority="Normal" RelationshipType="Microsoft.SQLServer.Core.AvailabilityGroupHostsAvailabilityDatabase" MemberMonitor="Health!System.Health.SecurityState">
<Category>SecurityHealth</Category>
<Algorithm>WorstOf</Algorithm>
</DependencyMonitor>