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_diskSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_compliance.control.compute_vm_utilizing_managed_disk --shareSQL
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  left join azure_subscription as sub on sub.subscription_id = vm.subscription_id;