turbot/azure_thrifty

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:

powerpipe control run azure_thrifty.control.network_public_ip_unattached

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_thrifty.control.network_public_ip_unattached --share

Steampipe 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