turbot/gcp

steampipe plugin install gcpsteampipe plugin install gcp
On This Page
Get Involved

Table: gcp_compute_address

Represents an address resource.

Each virtual machine instance has an ephemeral internal IP address and, optionally, an external IP address. To communicate between instances on the same network, you can use an instance's internal IP address. To communicate with the Internet and instances outside of the same network, you must specify the instance's external IP address.

Examples

Basic info

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

List of address which are not in use

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

Address count by each 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

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

.inspect gcp_compute_address

GCP Compute Address

NameTypeDescription
addressinetThe static IP address represented by this resource.
address_typetextThe type of address to reserve, either INTERNAL or EXTERNAL.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
creation_timestamptimestamp without time zoneThe creation timestamp of the resource.
descriptiontextA user-specified, human-readable description of the address.
idbigintThe unique identifier for the resource.
ip_versiontextThe IP version that will be used by this address.
kindtextThe type of the resource.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametextA friendly name that identifies the resource.
networktextThe URL of the network in which to reserve the address.
network_tiertextSpecifies the networking tier used for configuring this address.
prefix_lengthbigintSpecifies the prefix length if the resource represents an IP range.
projecttextThe GCP Project in which the resource is located.
purposetextSpecifies the purpose of the resource.
self_linktextThe server-defined URL for the resource.
statustextThe status of the address.
subnetworktextThe URL of the subnetwork in which to reserve the address.
titletextTitle of the resource.
usersjsonbA list of URLs of the resources that are using this address.