turbot/gcp

steampipe plugin install gcpsteampipe plugin install gcp
gcp_audit_policygcp_bigquery_datasetgcp_bigquery_jobgcp_bigquery_tablegcp_bigtable_instancegcp_cloudfunctions_functiongcp_compute_addressgcp_compute_backend_bucketgcp_compute_backend_servicegcp_compute_diskgcp_compute_disk_metric_read_opsgcp_compute_disk_metric_read_ops_dailygcp_compute_disk_metric_read_ops_hourlygcp_compute_disk_metric_write_opsgcp_compute_disk_metric_write_ops_dailygcp_compute_disk_metric_write_ops_hourlygcp_compute_firewallgcp_compute_forwarding_rulegcp_compute_global_addressgcp_compute_global_forwarding_rulegcp_compute_imagegcp_compute_instancegcp_compute_instance_metric_cpu_utilizationgcp_compute_instance_metric_cpu_utilization_dailygcp_compute_instance_metric_cpu_utilization_hourlygcp_compute_instance_templategcp_compute_machine_typegcp_compute_networkgcp_compute_node_groupgcp_compute_node_templategcp_compute_project_metadatagcp_compute_regiongcp_compute_resource_policygcp_compute_routergcp_compute_snapshotgcp_compute_ssl_policygcp_compute_subnetworkgcp_compute_target_https_proxygcp_compute_target_poolgcp_compute_target_ssl_proxygcp_compute_target_vpn_gatewaygcp_compute_url_mapgcp_compute_vpn_tunnelgcp_compute_zonegcp_dns_managed_zonegcp_dns_policygcp_dns_record_setgcp_iam_policygcp_iam_rolegcp_kms_keygcp_kms_key_ringgcp_logging_bucketgcp_logging_exclusiongcp_logging_metricgcp_logging_sinkgcp_monitoring_alert_policygcp_monitoring_groupgcp_monitoring_notification_channelgcp_organizationgcp_projectgcp_project_organization_policygcp_project_servicegcp_pubsub_snapshotgcp_pubsub_subscriptiongcp_pubsub_topicgcp_service_accountgcp_service_account_keygcp_sql_backupgcp_sql_databasegcp_sql_database_instancegcp_sql_database_instance_metric_connectionsgcp_sql_database_instance_metric_connections_dailygcp_sql_database_instance_metric_connections_hourlygcp_sql_database_instance_metric_cpu_utilizationgcp_sql_database_instance_metric_cpu_utilization_dailygcp_sql_database_instance_metric_cpu_utilization_hourlygcp_storage_bucket

Table: gcp_monitoring_alert_policy

An alerting policy describes a set of conditions that you want to monitor. These conditions might relate to the state of an unhealthy system or to resource consumption.

Examples

Basic info

select
display_name,
name,
enabled,
documentation ->> 'content' as doc_content,
tags
from
gcp_monitoring_alert_policy;

Get the creation record for each alert policy

select
display_name,
name,
creation_record ->> 'mutateTime' as mutation_time,
creation_record ->> 'mutatedBy' as mutated_by
from
gcp_monitoring_alert_policy;

Get the condition details for each alert policy

select
display_name,
con ->> 'displayName' as filter_display_name,
con -> 'conditionThreshold' ->> 'filter' as filter,
con -> 'conditionThreshold' ->> 'thresholdValue' as threshold_value,
con -> 'conditionThreshold' ->> 'trigger' as trigger
from
gcp_monitoring_alert_policy,
jsonb_array_elements(conditions) as con;

.inspect gcp_monitoring_alert_policy

GCP Monitoring Alert Policy

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
combinertextHow to combine the results of multiple conditions to determine if an incident should be opened.
conditionsjsonbA list of conditions for the policy.
creation_recordjsonbA read-only record of the creation of the alerting policy.
display_nametextA short name or phrase used to identify the policy in dashboards, notifications and incidents.
documentationjsonbDocumentation that is included with notifications and incidents related to this policy.
enabledbooleanIndicates whether the policy is enabled, or not.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
mutation_recordjsonbA read-only record of the most recent change to the alerting policy.
nametextThe resource name for this policy.
notification_channelsjsonbIdentifies the notification channels to which notifications should be sent when incidents are opened or closed or when new violations occur on an already opened incident.
projecttextThe GCP Project in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
user_labelsjsonbUser-supplied key/value data to be used for organizing and identifying the AlertPolicy objects.
validityjsonbRead-only description of how the alert policy is invalid.