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_kubernetes_clustergcp_kubernetes_node_poolgcp_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_compute_node_group

Represent a sole-tenant Node Group resource.

A sole-tenant node is a physical server that is dedicated to hosting VM instances only for specific project. Use sole-tenant nodes to keep the instances physically separated from instances in other projects, or to group the instances together on the same host hardware.

Examples

Node group basic info

select
name,
status,
size,
self_link
from
gcp_compute_node_group;

List of node groups where the autoscaler is not enabled

select
name,
id,
status,
autoscaling_policy_mode
from
gcp_compute_node_group
where
autoscaling_policy_mode <> 'ON';

List of node groups with default maintenance settings

select
name,
id,
status,
autoscaling_policy_mode
from
gcp_compute_node_group
where
maintenance_policy = 'DEFAULT';

List node types for node groups

select
g.name,
g.id,
g.location,
t.node_type
from
gcp_compute_node_group as g,
gcp_compute_node_template as t
where
g.node_template = t.self_link;

.inspect gcp_compute_node_group

GCP Compute Node Group

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
autoscaling_policy_max_nodesbigintThe maximum number of nodes that the group should have. Must be set if autoscaling is enabled. Maximum value allowed is 100.
autoscaling_policy_min_nodesbigintThe minimum number of nodes that the group should have.
autoscaling_policy_modetextSpecifies the autoscaling mode of the node group. Set to one of: ON, OFF, or ONLY_SCALE_OUT.
creation_timestamptimestamp without time zoneThe creation timestamp of the resource.
descriptiontextA user-specified, human-readable description of the node group.
fingerprinttextAn unique system generated string, to reduce conflicts when multiple users change any property of the resource.
iam_policyjsonbAn Identity and Access Management (IAM) policy, which specifies access controls for Google Cloud resources. A `Policy` is a collection of `bindings`. A `binding` binds one or more `members` to a single `role`. Members can be user accounts, service accounts, Google groups, and domains (such as G Suite). A `role` is a named list of permissions; each `role` can be an IAM predefined role or a user-created custom role. For some types of Google Cloud resources, a `binding` can also specify a `condition`, which is a logical expression that allows access to a resource only if the expression evaluates to `true`.
idbigintThe unique identifier for the resource.
kindtextThe type of the resource.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
maintenance_policytextSpecifies how to handle instances when a node in the group undergoes maintenance.
nametextA friendly name that identifies the resource.
node_templatetextThe URL of the node template to create the node group from.
projecttextThe GCP Project in which the resource is located.
self_linktextThe server-defined URL for the resource.
sizebigintThe total number of nodes in the node group.
statustextSpecifies the current state of the node group.
titletextTitle of the resource.
zonetextThe name of the zone where the node group resides.
zone_nametextThe zone name in which the node group resides.