Query: storage_account_infrastructure_encryption_status

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