SQL Sentry Condition Events Log

Introduction

The Events Log displays all the Advisory, General, Audit, and Failsafe condition events that are active or have completed.

Note:  Prior to version 2021.1, only advisory conditions appeared in the events log. See the SQL Sentry Event Log Updates Provide a Centralized View of Events blog post for more information.

SentryOne Events Log

Note:  Select the Column Chooser and add the Condition Type column to the grid view to easily view each condition's type (General, Audit, Failsafe, or Advisory).

SentryOne Events Log select Condition Type from the Column Chooser
SentryOne Events Log Condition Type Column

Event Log Information

Advisory, General, Audit, and Failsafe conditions will display different information in the Condition Evaluation and Condition Description panels. For example:

Select an Advisory Condition entry in the Grid view to display the following:

OptionDescription
1. Condition Evaluation PanelThe starting state of the event on the left panel.
2. Condition DescriptionA description of the advisory condition on the right panel.  

SentryOne Events Log Selected Entry

Select the End Time column of an Advisory Condition to display the following: 

OptionDescription
1. Condition Evaluation PanelThe result state that closed the active event on the left panel.
2. Condition DescriptionA description of the advisory condition on the right panel.

SentryOne Events Log Selected End Time

Select a General, Audit, or Failsafe Condition entry in the Grid view to display the following:

SentryOne Events Log Audit, General, or Failsafe Condition selected

OptionDescription
1. Condition Evaluation PanelThe message associated with the general, audit, or failsafe condition on the left panel.
2. Condition DescriptionA description of the general, audit, or failsafe condition on the right panel.

Adding Notes and Assigning Users

Select the Expansion node in the Notes column to add notes to the event. Select OK to save any added notes. SentryOne Events Log Add Notes

Note:  Any notes that you add to the condition will be included in the future notifications of that condition.

You also can assign users to events. Select the Assigned User column, and then select a user from the drop-down list. SentryOne Events Log Assign User

Note:  You can also automatically assign a user to all events of a particular Advisory Condition by selecting an Advisory Condition in the Conditions pane that has the Send to Alerting Channels action assigned to it, and selecting the user in the Action Settings tab. 

Note:  Assigning users to Advisory Condition events allows for users to quickly sort events and investigate any events that they've been assigned.

Context Menu Options

SentryOne Events Log Context Menu Options

OptionDescription
Jump To > Performance Analysis DashboardJumps to the time frame of the Advisory Condition event.
Jump To > NavigatorJumps to the target or instance where the Advisory Condition event was evaluated. 
Edit Advisory ConditionOpens the Advisory Condition Editor for the selected Advisory Condition.
Disable/Enable Advisory ConditionDisables or enables the selected Advisory Condition.
Snooze > This Condition/This ObjectDisables actions alerting on the selected Advisory Condition on the selected object for the selected period.
Snooze > This Condition/All ObjectsDisables actions and alerting on the selected Advisory Condition on all objects for the selected period.
Close > All for ObjectClose all event logs for objects. 
Close > All for ConditionClose all event logs for conditions.