Query: Ensure that Network Security Group Flow Log retention period is 'greater than 90 days'

Description

Network Security Group Flow Logs should be enabled and the retention period is set to greater than or equal to 90 days.

Query

Tables used in this query:

• azure_network_security_group
• azure_network_watcher_flow_log
• azure_subscription

Controls using this query:

• 6.4 Ensure that Network Security Group Flow Log retention period is 'greater than 90 days'
• 6.4 Ensure that Network Security Group Flow Log retention period is 'greater than 90 days'
• 6.5 Ensure that Network Security Group Flow Log retention period is 'greater than 90 days'
• 6.5 Ensure that Network Security Group Flow Log retention period is 'greater than 90 days'
• 6.5 Ensure that Network Security Group Flow Log retention period is 'greater than 90 days'
• 7.5 Ensure that Network Security Group Flow Log retention period is 'greater than 90 days'
• Ensure that Network Security Group Flow Log retention period is 'greater than 90 days'

SQL