Query: sql_server_vulnerability_assessment_disabled_count

with sql_server_va as (
  select
    distinct id
  from
    azure_sql_server as s,
    jsonb_array_elements(server_vulnerability_assessment) as va
  where
    va -> 'properties' -> 'recurringScans' ->> 'isEnabled' = 'true'
)
select
  count(*) as value,
  'Vulnerability Assessment Disabled' as label,
  case count(*) when 0 then 'ok' else 'alert' end as type
from
 azure_sql_server where id not in (select id from sql_server_va);