turbot/azure_thrifty
GitHub
Loading controls...

Control: Unattached external IP addresses should be removed

Description

Unattached external IPs cost money and should be released.

Usage

Run the control in your terminal:

steampipe check azure_thrifty.control.network_public_ip_unattached

Snapshot and share results via Steampipe Cloud:

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

Plugins & Tables

SQL

select
ip.id as resource,
case
when ip.ip_configuration_id is null then 'alarm'
else 'ok'
end as status,
case
when ip.ip_configuration_id is null then ip.title || ' has no associations.'
else ip.title || ' associated with network interface ' || split_part(ip.ip_configuration_id, '/', 9) || '.'
end as reason,
ip.resource_group,
display_name as subscription
from
azure_public_ip as ip,
azure_subscription as sub
where
sub.subscription_id = ip.subscription_id;

Tags