Control: Microsoft SQL elasticpools should not exceed tag limit
Description
Check if the number of tags on Microsoft SQL elasticpools do not exceed the limit.
Usage
Run the control in your terminal:
powerpipe control run azure_tags.control.mssql_elasticpool_tag_limit
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_tags.control.mssql_elasticpool_tag_limit --share
Steampipe Tables
SQL
with analysis as ( select id, title, cardinality(array(select jsonb_object_keys(tags))) as num_tag_keys, _ctx, tags, resource_group, subscription_id, region from azure_mssql_elasticpool)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 , subscription_id as subscription_idfrom analysis;
Params
Args | Name | Default | Description | Variable |
---|---|---|---|---|
$1 | tag_limit |
|