turbot/steampipe-mod-azure-compliance

Control: Ensure Virtual Machines are utilizing Managed Disks

Description

Migrate BLOB based VHD's to Managed Disks on Virtual Machines to exploit the default features of this configuration.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.compute_vm_utilizing_managed_disk

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_compliance.control.compute_vm_utilizing_managed_disk --share

SQL

This control uses a named query:

select
vm.id as resource,
case
when managed_disk_id is null then 'alarm'
else 'ok'
end as status,
case
when managed_disk_id is null then vm.name || ' VM not utilizing managed disks.'
else vm.name || ' VM utilizing managed disks.'
end as reason
, vm.resource_group as resource_group
, sub.display_name as subscription
from
azure_compute_virtual_machine as vm,
azure_subscription as sub
where
sub.subscription_id = vm.subscription_id;

Tags