Query: Ensure that Activity Log Alert exists for Delete Policy Assignment

Description

Create an activity log alert for the Delete Policy Assignment event.

Query

Tables used in this query:

• azure_log_alert
• azure_subscription

Controls using this query:

• 5.2.2 Ensure that Activity Log Alert exists for Delete Policy Assignment
• 5.2.2 Ensure that Activity Log Alert exists for Delete Policy Assignment
• 5.2.2 Ensure that Activity Log Alert exists for Delete Policy Assignment
• 5.2.2 Ensure that Activity Log Alert exists for Delete Policy Assignment
• 5.2.2 Ensure that Activity Log Alert exists for Delete Policy Assignment
• 6.1.2.2 Ensure that Activity Log Alert exists for Delete Policy Assignment
• 6.2.2 Ensure that Activity Log Alert exists for Delete Policy Assignment
• 7.1.2.2 Ensure that Activity Log Alert exists for Delete Policy Assignment
• Ensure that Activity Log Alert exists for Delete Policy Assignment

SQL