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. 2. Open the Conditions Pane (View > Conditions) and then select Audit Conditions from the dropdown menu.
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.
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.
|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.|
|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.|
|Audit: Performance Counter Added||A Performance Counter is added to an event object or event view.|
|Audit: Performance Counter Deleted||A Performance Counter is deleted from an event object or event view.|
|Audit: Performance Monitored Flag Changed||The Performance Monitored flag is changed for an event object or event view.|