turbot/azure_tags
Loading controls...

Control: SQL servers should be tagged

Description

Check if SQL servers have at least 1 tag.

Usage

Run the control in your terminal:

powerpipe control run azure_tags.control.sql_server_untagged

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_tags.control.sql_server_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,
resource_group,
subscription_id
from
azure_sql_server;