Control: DNS managed zones should not exceed label limit

Description

Check if the number of labels on DNS managed zones do not exceed the limit.

Usage

Run the control in your terminal:

powerpipe control run gcp_labels.control.dns_managed_zone_label_limit

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run gcp_labels.control.dns_managed_zone_label_limit --share

Steampipe Tables

gcp_dns_managed_zone

SQL

with analysis as (
  select
    self_link,
    title,
    cardinality(
      array(
        select
          jsonb_object_keys(labels)
      )
    ) as num_label_keys,
    location,
    project
  from
    gcp_dns_managed_zone
)
select
  self_link as resource,
  case
    when num_label_keys > $1 :: integer then 'alarm'
    else 'ok'
  end as status,
  title || ' has ' || num_label_keys || ' label(s).' as reason,
  location,
  project
from
  analysis

Params

Args	Name	Default	Description	Variable
$1	label_limit	`60`		label_limit