Query: sql_server_vulnerability_assessment

select
  a ->> 'name' as "Name",
  a -> 'properties' -> 'recurringScans' -> 'isEnabled' as "Is Enabled",
  a -> 'properties' -> 'recurringScans' -> 'emailSubscriptionAdmins' as "Email Subscription Admins",
  a ->> 'id' as "ID"
from
  azure_sql_server,
  jsonb_array_elements(server_vulnerability_assessment) as a
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);