Query: sql_database_geo_redundant_backup_disabled_count

select
  count(*) as value,
  'Geo-Redundant Backup Disabled' as label,
  case
    count(*)
    when 0 then 'ok'
    else 'alert'
  end as type
from
  azure_sql_database
where
  not (
    retention_policy_property ->> 'monthlyRetention' <> 'PT0S'
    or retention_policy_property ->> 'weeklyRetention' <> 'PT0S'
    or retention_policy_property ->> 'yearlyRetention' <> 'PT0S'
  );