SQL Sentry Audit Conditions

Introduction

Audit Conditions are applicable to various activities inside and outside of the SQL Sentry client. Audit Conditions provide a way to be notified when various settings are changed, or monitored objects are modified from within the SQL Sentry client. Audit Conditions have an assigned default severity and associated tags, and will affect your environment's Environmental Health Score (EHO).

Note: The Log to Database action is configured by default for all Audit Conditions. This gives you an audit trail concerning changes to your SQL Sentry environment. If you'd like to be notified about Audit Conditions happening in your environment, configure the Send Email Action.

Configuring Actions for Audit Conditions

To add a Audit Condition, complete the following steps:

1. Open the Navigator pane (View > Navigator), and then select the desired node where you want to configure an action.
SQL Sentry Navigator Pane select desired node

2. Open the Conditions Pane (View > Conditions) and then select Audit Conditions from the dropdown menu.

SQL Sentry Conditions Pane select Audit Conditions

3. 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 this condition being met, and then select OK.
Actions Selector Audit Conditions

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

For a complete listing of all Audit Conditions, see the following tables.

Event Chain

Condition	Description
Audit: Event Chain Created	An Event Chain is created.
Audit: Event Chain Deleted	An Event Chain is deleted.
Audit: Event Chain Modified	An Event Chain is modified.

Global

Condition	Description
Audit: Actions Changed	A configured action is changed for an object.
Audit: Event Object Created	An Event Object (job, task, etc.) is created.
Audit: Event Object Deleted	An Event Object (job, task, etc.) is deleted.
Audit: Event Object Properties Modified	An Event Object's (job, task, etc.) properties are modified.
Audit: Event Object Rescheduled	An Event Object (job, task, etc.) is rescheduled. For some object types, this condition is only detected when rescheduling in the SQL Sentry client by dragging-and-dropping.
Audit: Notes Changed	A note is changed.
Audit: Settings Changed	Object or application settings are changed.
Audit: Watched Flag Changed	The watched flag is changed for an object.

Performance Counter