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;