General Conditions

General Conditions are applicable to monitored Event Objects or associated Performance Counters. These are the most common conditions that configure actions within your environment. Not all General Conditions apply to all Event Object types. A condition must be supported by an object's underlying event provider for conditions and actions to be available in SentryOne.

Configuring Actions for General Conditions

Configure actions in response to General Conditions being met at these levels: shared groups (global), sites, target groups, targets, and instances.

Select the node appropriate to the level you'd like to configure the action for in the Navigator pane, and then select the General Actions tab in the Conditions pane. If you don't see the Conditions pane, use View > Conditions.

Select Add in the Conditions pane to open the Actions Selector. Expand the applicable object and condition. Use the checkbox(es) to select which actions should be taken in response to the condition being met, and then select OK.

SentryOne Action Selector

For more information about actions that can be taken when a condition is met, see the Actions topic.

Common General Conditions

The following table contains a description of common General Conditions.

ConditionsIs Met When
StartedOccurs when an event instance begins.
CompletedOccurs when an event instance finishes running, regardless of success or failure status.
SuccessOccurs when an event instance completes and returns a success status.
FailureOccurs when an event instance completes and returns a failure status.
Output Content MatchThis condition is met when specific content that you define exists in the output message text for an event instance. For more information, see the Output Content Match topic.
Runtime Threshold MinOccurs when an event runs shorter than x% of its average runtime, or shorter than an explicit duration.
Runtime Threshold MaxOccurs when an event runs longer than x% of its average runtime, or longer than an explicit duration.
Performance Counter Threshold MinOccurs when a minimum performance threshold has been set for a performance counter, and the counter's value falls beneath it.
Performance Counter Threshold MaxOccurs when a maximum performance threshold has been set for a performance counter, and the counter's value exceeds it.

General Conditions Comprehensive list

Use the following links to jump to a description of the various conditions. For each condition, find a column that lists related settings that affect the condition. Settings define criteria for when a condition is met, including runtime thresholds for events that are captured. Certain settings, known as Source Settings, define what events are collected by SentryOne. For more information about settings, see the Settings topic.

APS Distribution Queries

ConditionsDescriptions
CompletedAPS Distribution query completed.
Duration Threshold MaxAPS Distributed Queries exceeded the maximum duration threshold.
Duration Threshold MinAPS Distributed Queries exceeded the minimum duration threshold.
FailureAPS Distribution query failed.
Output Content MatchA match condition was found in the output content of an APS Distribution query.
StartedAPS Distribution query started.
Step FailureAPS Distribution query step failed.
SuccessAPS Distribution query succeeded.

APS Health Alert

ConditionsDescriptions
Critical errorA critical error event occurred. 
Non-critical errorA non-critical error occurred. 
Output Content MatchA match condition was found in the output content of an APS Health Alert.

APS Loader Backup Run

ConditionsDescriptions
CompletedAPS Loader Backup run completed. 
Duration Threshold MaxAPS Loader Backup Run exceeded the maximum duration threshold.
Duration Threshold MinAPS Loader Backup Run exceeded the minimum duration threshold.
FailureAPS Loader Backup run failed. 
Output Content MatchA match condition was found in the output content of an APS Loader Backup run. 
Started APS Loader Backup run started.
Step FailureAPS Loader Backup run step failed
SuccessAPS Loader Backup run succeeded.

Azure SQL Data Warehouse Distributed Queries

ConditionsDescriptions
CompletedAzure SQL Data Warehouse Distributed query completed.
Duration Threshold MaxAzure SQL Data Warehouse Distributed Queries exceeded the maximum duration threshold.
Duration Threshold MinAzure SQL Data Warehouse Distributed Queries exceeded the minimum duration threshold.
FailureAzure SQL Data Warehouse Distributed query failed.
Output Content MatchA match condition was found in the output content of an Azure SQL Data Warehouse Distributed query. 
Started Azure SQL Data Warehouse Distributed query started
Step FailureAzure SQL Data Warehouse Distributed query step failed.
SuccessAzure SQL Data Warehouse Distributed query succeeded. 

Azure SQL Data Warehouse Loader Backup Run

ConditionsDescriptions
Completed Azure SQL Data Warehouse Loader Backup run completed.
Duration Threshold MaxAzure SQL Data Warehouse Loader Backup Run exceeded the maximum duration threshold.
Duration Threshold MinAzure SQL Data Warehouse Loader Backup Run exceeded the minimum duration threshold.
FailureAzure SQL Data Warehouse Loader Backup run failed.
Output Content MatchA match condition was found in the output content of an Azure SQL Data Warehouse Loader Backup run.
StartedAzure SQL Data Warehouse Loader Backup run started.
Step FailureAzure SQL Data Warehouse Loader Backup run step failed.
SuccessAzure SQL Data Warehouse Loader Backup run succeeded.

Blocking SQL

ConditionsDescriptionRelated Setting
Blocking SQLA Block is detected, subject to the Minimum Block Duration set for the Blocking SQL Source. View the Block on the Event Calendar or the Performance Analysis Blocking SQL tab.Blocking SQL Source: Minimum Block Duration
Blocking SQL: Duration Threshold MaxBlock exceeded the maximum duration threshold.Blocking SQL Source: Minimum Block Duration

Blocking SQL: Maximum Duration Threshold
Blocking SQL: Output Content MatchA match condition is found in the output content of a Block.

Blocking SQL Source: Minimum Block Duration

Condition Settings

Deadlocks

ConditionsDescriptionRelated Setting
Amazon RDS for SQL Server: Deadlock: Output Content MatchA match condition is found in the output content of an Amazon RDS for SQL deadlock.Deadlocks Source: Collect Deadlock Events
DeadlockA Deadlock was detected. View the Deadlock on the Event Calendar or the Performance Analysis Deadlocks tab.Deadlocks Source: Collect Deadlock Events
Deadlock: Output Content MatchA match condition is found in the output content of a Block. Define which strings to search for in the event output to trigger this condition. For more information, see the Condition Settings topic.Deadlocks Source: Collect Deadlock Events

Condition Settings

Event Chain

ConditionsDescriptionRelated Setting
CompletedEvent Chain execution completed.N/A
FailureEvent Chain execution failed.N/A
Runtime Threshold MaxEvent Chain exceeded the maximum runtime threshold.Event Chain: Maximum Runtime Threshold
Runtime Threshold MinEvent Chain didn't meet the minimum runtime threshold.Event Chain: Minimum Runtime Threshold
StartedEvent Chain execution started.N/A
SuccessEvent Chain execution succeeded.N/A

Event Chain Node

ConditionsDescriptionRelated Setting
CompletedEvent Chain node execution completed.N/A
FailureEvent Chain node execution failed.N/A
Runtime Threshold MaxThe runtime threshold maximum for an Event Chain node was exceeded.Event Chain Node: Maximum Runtime Threshold
Runtime Threshold MinEvent Chain node didn't meet the minimum runtime threshold.Event Chain Node: Minimum Runtime Threshold
StartedEvent Chain node execution started.N/A
SuccessEvent Chain node execution succeeded.N/A

 Index

ConditionsDescriptionRelated Setting
Defragmentation CompleteIndex Defragmentation completed.Index Defragmentation
Defragmentation FailureIndex Defragmentation failed.Index Defragmentation
Defragmentation StartedIndex Defragmentation started.Index Defragmentation

 Maintenance Plan

ConditionsDescriptionRelated Setting
Output Content MatchA match condition was found in the output content of a maintenance plan.Condition Settings
Step FailureMaintenance plan step failed.N/A

Performance Counter

ConditionsDescriptionRelated Setting
Threshold MaxPerformance Counter value exceeded the maximum threshold.Performance Counter: Counter Thresholds Maximum
Threshold MinPerformance Counter didn't meet the minimum thresholdPerformance Counter: Counter Thresholds Minimum

Reporting Services Report

ConditionsDescriptionRelated Setting
CompletedReporting Services Report completed.N/A
FailureReporting Services Report failed.N/A
Runtime Threshold MaxReporting Services Report exceeded the maximum runtime threshold.Reporting Services Report: Maximum Runtime Threshold
Runtime Threshold MinReporting Services Report didn't meet the minimum runtime threshold.Reporting Services Report: Minimum Runtime Threshold
StartedReporting Services Report started.N/A
SuccessReporting Services Report succeeded.N/A

SQL Server Agent Alert

ConditionsDescriptionRelated Setting
Alert FiredSQL Server Agent Alert was fired.N/A
Output Content MatchA match condition is found in the output content of a SQL Server Agent Alert.Condition Settings

 SQL Server Agent Job

ConditionsDescriptionRelated Setting
BlockSQL Server Agent Job is blocked or is blocking.

The minimum block duration required to trigger SQL Server Agent Job: Block condition can be changed in the Monitoring Service Setting.

Monitoring Service > Settings > Event Monitor

CompletedSQL Server Agent Job completed.N/A
ConflictThere's a job conflict, meaning two or more jobs were seen running concurrently.N/A
FailureSQL Server Agent Job failed.N/A
Output Content MatchA match condition is found in the output content of a SQL Server Agent Job.Condition Settings
QueuedSQL Server Agent Job is queued via SentryOne's queuing system.SQL Server Agent Job: Queue Type
RetrySQL Server Agent Job step was retried.N/A
Run MissedThe scheduled run for a job was missed for some reason. This may be because SQL Server Agent was offline.SQL Server Agent Jobs Source: Missed Run Threshold
Runtime Threshold MaxSQL Server Agent Job exceeded the maximum runtime threshold.SQL Server Agent Job: Maximum Runtime Threshold
Runtime Threshold MinSQL Server Agent Job didn't meet the minimum runtime threshold.SQL Server Agent Job: Minimum Runtime Threshold
StartedSQL Server Agent Job started.N/A
Step FailureSQL Server Agent Job step failed.N/A
SuccessSQL Server Agent Job succeeded.N/A

SQL Server Agent Log

ConditionsDescriptionRelated Setting
ErrorAn error event occurred in the SQL Server Agent Log.N/A
Output Content MatchA match condition is found in the output content of a SQL Server Agent Log.Condition Settings
WarningA warning event occurred in the SQL Server Agent Log.N/A

Top Commands

ConditionsDescriptionRelated Setting
Top Commands: CompletedAn Analysis Services command (MDX or XMLA) completed. 
Important:  It's highly recommended that a response ruleset be used with this condition to avoid excessive logging.
Top Commands Source: Collect MDX/DMX/XMLA Events

Top Commands Source: Minimum Duration
Top Commands: Duration Threshold MaxThe duration threshold maximum was exceeded for an Analysis Services command (MDX or XMLA).Condition Settings
Top Commands: ErrorAn Analysis Services command (MDX or XMLA) completed with an error.Top Commands Source: Collect MDX/DMX/XMLA Events

Top Commands Source: Minimum Duration
Top Commands: Output Content MatchA match condition is found in a completed Analysis Services command (MDX or XMLA).Top Commands Source: Collect MDX/DMX/XMLA Events

Top Commands Source: Minimum Duration

Condition Settings

Top SQL

ConditionsDescriptionRelated Setting
Amazon RDS for SQL Server: Top SQL: Duration Threshold MaxTop SQL event exceeded the maximum duration threshold.Top SQL Source
Amazon RDS for SQL Server: Top SQL: Duration Threshold MinTop SQL event exceeded the minimum duration threshold.Top SQL Source
Amazon RDS for SQL Server: Top SQL: Output Content MatchA match condition is found in the output content of an Amazon RDS for SQL Top SQL.Top SQL Source
Azure SQL DB: Top SQL: Duration Threshold MaxTop SQL event exceeded the maximum duration threshold.Top SQL Source
Azure SQL DB: Top SQL: Duration Threshold MinTop SQL event exceeded the minimum duration threshold.Top SQL Source
Azure SQL DB: Top SQL: Output Content MatchA match condition is found in the output content of an Azure SQL DB Top SQL.Top SQL Source
Top SQL: CompletedTop SQL event completed.
Important:  It's highly recommended that a ruleset be used with this condition to avoid excessive logging.
Top SQL Source
Top SQL: Duration Threshold MaxTop SQL event exceeded the maximum runtime threshold.Top SQL Source
Top SQL: Duration Threshold MinTop SQL event exceeded the minimum runtime threshold.Top SQL Source
Top SQL: ErrorTop SQL event completed with an error.Top SQL Source
Top SQL: Output Content MatchA match condition is found in the content of a completed Top SQL event.Top SQL Source

Condition Settings

Windows Computer 

ConditionDescriptionRelated Setting
Virtual Machine: VM MovedThe Virtual Machine Moved.Virtual Machine: VM Support

Windows Event Log

ConditionsDescriptionRelated Setting
Windows Event Log: Event

An event occurred in a Windows Event Log.

Note:  Condition Settings can help to restrict which events you are alerted about

Windows Event Logs Source: History Filter

Windows Task

ConditionsDescriptionRelated Setting
CompletedWindows Task completed.N/A
FailureWindows Task failed, as determined by the success Exit Code setting for the task.N/A
Output Content MatchA match condition is found in the output content for a Windows Task.Condition Settings
Runtime Threshold MaxWindows Task exceeded the maximum runtime threshold.Windows Task: Maximum Runtime Threshold
Runtime Threshold MinWindows Task didn't meet the minimum runtime threshold.Windows Task: Minimum Runtime Threshold
StartedWindows Task started.N/A
SuccessWindows Task succeeded, as determined by the success Exit Code setting for the task.N/A