Query: Ensure that 'Auditing' Retention is 'greater than 90 days'

Description

SQL Server Audit Retention should be configured to be greater than 90 days.

Query

Tables used in this query:

• azure_sql_server
• azure_subscription

Controls using this query:

• 4.1.3 Ensure that 'Auditing' Retention is 'greater than 90 days'
• 4.1.3 Ensure that 'Auditing' Retention is 'greater than 90 days'
• 4.1.6 Ensure that 'Auditing' Retention is 'greater than 90 days'
• 4.1.6 Ensure that 'Auditing' Retention is 'greater than 90 days'
• 4.1.6 Ensure that 'Auditing' Retention is 'greater than 90 days'
• 5.1.6 Ensure that 'Auditing' Retention is 'greater than 90 days'
• Ensure that 'Auditing' Retention is 'greater than 90 days'

SQL