steampipe plugin install gcp

Table: gcp_monitoring_group - Query GCP Monitoring Groups using SQL

A Monitoring Group in Google Cloud Platform (GCP) is a named set of Google Cloud resources identified by a filter. These groups provide a way to monitor and manage the combined behavior of a collection of related resources. They are useful for aggregate analysis and for building higher-level, more abstract collections.

Table Usage Guide

The gcp_monitoring_group table provides insights into Monitoring Groups within Google Cloud Monitoring. As a DevOps engineer, explore group-specific details through this table, including resource type, group name, and associated metadata. Utilize it to uncover information about groups, such as those with specific configurations, the relationships between groups, and the verification of group metrics.

Examples

Filter info of each monitoring group

Explore which monitoring groups are in use in your Google Cloud Platform setup. This allows for better management of your resources by understanding the filters applied to each group.

select
name,
display_name,
filter
from
gcp_monitoring_group;
select
name,
display_name,
filter
from
gcp_monitoring_group;

List of cluster monitoring groups

Discover the segments that are grouped into clusters within the Google Cloud Platform's monitoring system, allowing you to better manage and organize your monitoring resources.

select
name,
display_name,
is_cluster
from
gcp_monitoring_group
where
is_cluster;
select
name,
display_name,
is_cluster
from
gcp_monitoring_group
where
is_cluster = 1;

Schema for gcp_monitoring_group

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
display_nametextA user-assigned name for this group, used only for display purposes.
filtertextThe filter used to determine which monitored resources belong to this group.
is_clusterbooleanIf true, the members of this group are considered to be a cluster. The system can perform additional analysis on groups that are clusters.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametext=The name of this group
parent_nametextThe name of the group's parent, if it has one.
projecttext=, !=, ~~, ~~*, !~~, !~~*The GCP Project in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle of the resource.

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_group