Control: SOA refresh value should be between 1200 and 43200 seconds (12 minutes to 12 hours)

Usage

Run the control in your terminal:

steampipe check net_insights.control.dns_soa_refresh_value_check

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share net_insights.control.dns_soa_refresh_value_check

net_dns_record

Params

["github.com","microsoft.com"]

SQL

select
  domain as resource,
  case
    when refresh < 1200
    or refresh > 43200 then 'alarm'
    else 'ok'
  end as status,
  domain || ' SOA refresh value is ' || refresh || ' second(s).' as reason
from
  net_dns_record
where
  domain in (
    select
      jsonb_array_elements_text(to_jsonb($1 :: text [ ]))
  )
  and type = 'SOA';