Query: storage_account_blob_logging

select
  blob_service_logging ->> 'Delete' as "Delete",
  blob_service_logging ->>'Read' as "Read",
  blob_service_logging ->> 'Write' as "Write",
  blob_service_logging -> 'RetentionPolicy' ->> 'Enabled' as "Retention Policy Enabled",
  blob_service_logging -> 'RetentionPolicy' ->> 'Days' as "Retention Days"
from
  azure_storage_account
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);