turbot/azure_insights

Query: compute_virtual_machine_host_encryption_count

Usage

powerpipe query azure_insights.query.compute_virtual_machine_host_encryption_count

SQL

select
count(*) as value,
'Unencrypted Host' as label,
case
count(*)
when 0 then 'ok'
else 'alert'
end as type
from
azure_compute_virtual_machine
where
security_profile -> 'encryptionAtHost' <> 'true'
or security_profile -> 'encryptionAtHost' is null;

Dashboards

The query is used in the dashboards: