turbot/azure_tags

Control: Stream Analytics jobs should not exceed tag limit

Description

Check if the number of tags on Stream Analytics jobs do not exceed the limit.

Usage

Run the control in your terminal:

powerpipe control run azure_tags.control.stream_analytics_job_tag_limit

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_tags.control.stream_analytics_job_tag_limit --share

Steampipe 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_stream_analytics_job
)
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;