Table: gcp_compute_address - Query Google Cloud Compute Engine Addresses using SQL

An Address in Google Cloud Compute Engine is a static, external IP address that you reserve and assign to your instances. These reserved addresses can be used by cloud resources in the same region. They provide a reliable endpoint for your cloud services and are essential for load balancing and other network configurations.

Table Usage Guide

The gcp_compute_address table provides insights into the static, external IP addresses reserved within Google Cloud Compute Engine. As a network administrator, explore address-specific details through this table, including their status, type, and associated instances. Utilize it to oversee the allocation and usage of addresses, ensuring optimal network configurations and resource allocation.

Examples

Basic info

This query can be used to gain insights into the various IP addresses associated with your Google Cloud Platform (GCP) Compute Engine. It helps in understanding the type, creation time, IP version, status, associated subnetwork, and location of each address, which can be beneficial for managing and optimizing your network infrastructure.

select
  address,
  id,
  address_type,
  creation_timestamp,
  ip_version,
  status,
  subnetwork,
  location
from
  gcp_compute_address;

select
  address,
  id,
  address_type,
  creation_timestamp,
  ip_version,
  status,
  subnetwork,
  location
from
  gcp_compute_address;

List of address which are not in use

Discover the segments that consist of unused addresses in your Google Cloud Platform Compute Engine. This can help manage resources effectively by identifying and potentially freeing up unused addresses.

select
  address,
  address_type,
  creation_timestamp,
  status
from
  gcp_compute_address
where
  status != 'IN_USE';

select
  address,
  address_type,
  creation_timestamp,
  status
from
  gcp_compute_address
where
  status != 'IN_USE';

Address count by each network_tier

Analyze the distribution of addresses across different network tiers in your Google Cloud Platform to better understand your resource allocation. This could be useful in optimizing network performance and managing costs effectively.

select
  network_tier,
  count(*)
from
  gcp_compute_address
group by
  network_tier
order by
  network_tier;

select
  network_tier,
  count(*)
from
  gcp_compute_address
group by
  network_tier
order by
  network_tier;

Get details of users that are using an address

Gain insights into the details of users who are utilizing a specific address. This can be particularly useful for understanding user distribution and managing resources efficiently.

select
  name,
  address,
  id,
  jsonb_pretty(users)
from
  gcp_compute_address
where
  name = 'test2';

select
  name,
  address,
  id,
  users
from
  gcp_compute_address
where
  name = 'test2';

Query examples

compute_addresses_for_compute_subnetwork

Schema for gcp_compute_address

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
address	inet		The static IP address represented by this resource.
address_type	text	!=, =	The type of address to reserve, either INTERNAL or EXTERNAL.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
creation_timestamp	timestamp with time zone		The creation timestamp of the resource.
description	text		A user-specified, human-readable description of the address.
id	bigint		The unique identifier for the resource.
ip_version	text		The IP version that will be used by this address.
kind	text		The type of the resource.
location	text		The GCP multi-region, region, or zone in which the resource is located.
name	text	=	A friendly name that identifies the resource.
network	text		The URL of the network in which to reserve the address.
network_tier	text	!=, =	Specifies the networking tier used for configuring this address.
prefix_length	bigint		Specifies the prefix length if the resource represents an IP range.
project	text		The GCP Project in which the resource is located.
purpose	text	!=, =	Specifies the purpose of the resource.
self_link	text		The server-defined URL for the resource.
status	text	!=, =	The status of the address.
subnetwork	text		The URL of the subnetwork in which to reserve the address.
title	text		Title of the resource.
users	jsonb		A list of URLs of the resources that are using this address.

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_compute_address