Query: storage_account_blob_soft_delete_status

select
  blob_soft_delete,
  count(*)
from (
  select
    case when blob_soft_delete_enabled then
      'enabled'
    else
      'disabled'
    end blob_soft_delete
  from
    azure_storage_account) as cd
group by
  blob_soft_delete
order by
  blob_soft_delete;