Query: List of unassociated elastic IPs

Description

Discover the segments that consist of unassigned public IPs in your Azure infrastructure. This is useful in identifying potential cost savings, as you may be billed for these unassociated resources.

Query

Tables used in this query:

• azure_public_ip

SQL

select
  name,
	ip_configuration_id
from
  azure_public_ip
where
  ip_configuration_id is null;

select
  name,
  ip_configuration_id
from
  azure_public_ip
where
  ip_configuration_id is null;