Control: Unused reserved public IP addresses should be removed

Usage

Run the control in your terminal:

steampipe check oci_thrifty.control.network_public_ip_unattached

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share oci_thrifty.control.network_public_ip_unattached

oci_core_public_ip

oci_identity_compartment

SQL

select
  a.id as resource,
  case
    when a.lifecycle_state = 'AVAILABLE' then 'alarm'
    else 'ok'
  end as status,
  a.display_name || ' in ' || a.lifecycle_state || ' state.' as reason,
  a.scope,
  coalesce(c.name, 'root') as compartment
from
  oci_core_public_ip as a
  left join oci_identity_compartment as c on c.id = a.compartment_id;

Tags