Query: Ensure that the log metric filter and alerts exist for Custom Role changes

Description

It is recommended that a metric filter and alarm be established for changes to Identity and Access Management (IAM) role creation, deletion and updating activities.

Query

Tables used in this query:

• gcp_logging_metric
• gcp_monitoring_alert_policy
• gcp_project

Controls using this query:

• 2.6 Ensure that the log metric filter and alerts exist for Custom Role changes
• 2.6 Ensure that the log metric filter and alerts exist for Custom Role changes
• 2.6 Ensure that the log metric filter and alerts exist for Custom Role changes
• 2.6 Ensure That the Log Metric Filter and Alerts Exist for Custom Role Changes
• Ensure that the log metric filter and alerts exist for Custom Role changes

SQL