steampipe plugin install gcp

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
descriptiontextA user-specified, human-readable description of the notification channel.
display_nametext!=, =A human-readable name for the notification channel.
enabledbooleanSpecifies whether the notifications are forwarded to the described channel, or not.
labelsjsonbA set of labels attached with the notification channel.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametext=The full REST resource name for this channel.
projecttext=, !=, ~~, ~~*, !~~, !~~*The GCP Project in which the resource is located.
self_linktextServer-defined URL for the resource.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetext!=, =Specifies the type of the notification channel.
user_labelsjsonbA list of user-supplied key/value data that does not need to conform to the corresponding NotificationChannelDescriptor's schema unlike the labels field.
verification_statustextSpecifies 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