Table: gcp_monitoring_notification_channel - Query GCP Monitoring Notification Channels using SQL

GCP Monitoring Notification Channels are a part of Google Cloud Monitoring that allows you to configure where and how you want to receive notifications when incidents occur. These channels can be configured to send notifications via email, SMS, or to third-party services. This enables you to stay informed about the health and performance of your GCP resources and take appropriate actions when predefined conditions are met.

Table Usage Guide

The gcp_monitoring_notification_channel table provides insights into Monitoring Notification Channels within Google Cloud Platform. As a DevOps engineer or system administrator, explore channel-specific details through this table, such as the type of channel, display name, labels, and verification status. Utilize it to manage and monitor your notification channels effectively, ensuring you receive timely alerts about incidents in your GCP resources.

Examples

List of monitoring notification channel which are not verified

Determine the areas in which certain monitoring notification channels remain unverified. This query is useful for identifying potential gaps in your monitoring system, allowing for prompt verification and ensuring comprehensive coverage.

select
  name,
  display_name,
  type,
  verification_status
from
  gcp_monitoring_notification_channel
where
  verification_status <> 'VERIFIED';

select
  name,
  display_name,
  type,
  verification_status
from
  gcp_monitoring_notification_channel
where
  verification_status <> 'VERIFIED'
  OR verification_status is null;

List of monitoring notification channel which are not enabled

Explore which monitoring notification channels in your Google Cloud Platform are not currently enabled. This can help you identify potential gaps in your monitoring strategy and ensure that all necessary channels are active.

select
  name,
  display_name,
  enabled
from
  gcp_monitoring_notification_channel
where
  not enabled;

select
  name,
  display_name,
  enabled
from
  gcp_monitoring_notification_channel
where
  enabled = 0;

Schema for gcp_monitoring_notification_channel

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
description	text		A user-specified, human-readable description of the notification channel.
display_name	text	!=, =	A human-readable name for the notification channel.
enabled	boolean		Specifies whether the notifications are forwarded to the described channel, or not.
labels	jsonb		A set of labels attached with the notification channel.
location	text		The GCP multi-region, region, or zone in which the resource is located.
name	text	=	The full REST resource name for this channel.
project	text	=, !=, ~~, ~~, !~~, !~~	The GCP Project in which the resource is located.
self_link	text		Server-defined URL for the resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text	!=, =	Specifies the type of the notification channel.
user_labels	jsonb		A list of user-supplied key/value data that does not need to conform to the corresponding NotificationChannelDescriptor's schema unlike the labels field.
verification_status	text		Specifies whether this channel has been verified, or not.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- gcp

You can pass the configuration to the command with the --config argument:

steampipe_export_gcp --config '<your_config>' gcp_monitoring_notification_channel