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_compute_project_metadata

Compute project metadata authoritatively manages metadata common to all instances for a project in GCE.

Examples

Basic info

select
name,
id,
default_service_account,
creation_timestamp
from
gcp_compute_project_metadata;

Check if OS Login is enabled for Linux instances in the project

select
name,
id
from
gcp_compute_project_metadata,
jsonb_array_elements(common_instance_metadata -> 'items') as q
where
common_instance_metadata -> 'items' @> '[{"key": "enable-oslogin"}]'
and q ->> 'key' ilike 'enable-oslogin'
and q ->> 'value' not ilike 'TRUE';

.inspect gcp_compute_project_metadata

GCP Compute Project Metadata

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
common_instance_metadatajsonbMetadata key/value pairs available to all instances contained in this project.
creation_timestamptimestamp without time zoneCreation timestamp in RFC3339 text format.
default_network_tiertextThis signifies the default network tier used for configuring resources of the project and can only take the following values: PREMIUM, STANDARD.
default_service_accounttextDefault service account used by VMs running in this project.
descriptiontextAn optional textual description of the resource.
enabled_featuresjsonbRestricted features enabled for use on this project.
idtextThe unique identifier for the resource.
kindtextThe type of the resource.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametextThe ID of the project.
projecttextThe GCP Project in which the resource is located.
quotasjsonbQuotas assigned to this project.
self_linktextServer-defined URL for the resource.
titletextTitle of the resource.
usage_export_locationjsonbThe naming prefix for daily usage reports and the Google Cloud Storage bucket where they are stored.
xpn_project_statustextThe role this project has in a shared VPC configuration.