Title: The DBMS must provide an immediate real-time alert to appropriate support staff of all audit failure events requiring real-time alerts.
Vulnerability ID: V-58059
IA Controls: None
Description: It is critical for the appropriate personnel to be aware if a system is at risk of failing to process audit logs as required. Without a real-time alert, security personnel may be unaware of an impending failure of the audit capability, and system operation may be adversely affected. The appropriate support staff include, at a minimum, the ISSO and the DBA/SA. Alerts provide organizations with urgent messages. Real-time alerts provide these messages immediately (i.e., the time from event detection to alert occurs in seconds or less).
Check Text: Review the system documentation to determine which audit failure events require real-time alerts.
Review the DBMS settings and code. If the real-time alerting that is specified in the documentation is not enabled, this is a finding
Fix Text: Configure the system to provide an immediate real-time alert to appropriate support staff when a specified audit failure occurs.[divider]
SQL Server is able to be configured to send alerts upon Audit event failure.
This can be done with Event Notifications and SQL Agent jobs configured to sent alerts in certain conditions.
The SQL Agent job would have to be configured to monitor the system log files or audit DMVs at regular intervals to see if new information has been logged and then respond accordingly.
Third party auditing tools may also provide this capability.