Query: sql_database_vulnerability_assessment

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