turbot/azure_tags

Control: Microsoft SQL managed instances should be tagged

Description

Check if Microsoft SQL managed instances have at least 1 tag.

Usage

Run the control in your terminal:

powerpipe control run azure_tags.control.mssql_managed_instance_untagged

Snapshot and share results via Turbot Pipes:

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

Steampipe Tables

SQL

select
id as resource,
case
when tags is not null or tags::text <> '{}' then 'ok'
else 'alarm'
end as status,
case
when tags is not null or tags::text <> '{}' then title || ' has tags.'
else title || ' has no tags.'
end as reason
, subscription_id as subscription_id
from
azure_mssql_managed_instance;