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 loginpowerpipe 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 subscriptionfrom azure_compute_virtual_machine as vm, azure_subscription as subwhere sub.subscription_id = vm.subscription_id;