turbot/azure_tags
GitHub
Loading controls...

Control: Network watcher flow logs should not exceed tag limit

Description

Check if the number of tags on Network watcher flow logs do not exceed the limit.

Usage

Run the control in your terminal:

steampipe check azure_tags.control.network_watcher_flow_log_tag_limit

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share azure_tags.control.network_watcher_flow_log_tag_limit

Plugins & Tables

Params

ArgsNameDefaultDescriptionVariable
$1tag_limit
45

SQL

with analysis as (
select
id,
title,
cardinality(
array(
select
jsonb_object_keys(tags)
)
) as num_tag_keys,
resource_group,
subscription_id
from
azure_network_watcher_flow_log
)
select
id as resource,
case
when num_tag_keys > $1 :: integer then 'alarm'
else 'ok'
end as status,
title || ' has ' || num_tag_keys || ' tag(s).' as reason,
resource_group,
subscription_id
from
analysis;