Query: Virtual machine scale sets should use managed disks

Description

This policy identifies Azure Virtual machine scale sets which are not utilising Managed Disks. Using Azure Managed disk over traditional BLOB storage based VHD's has more advantage features like Managed disks are by default encrypted, reduces cost over storage accounts and more resilient as Microsoft will manage the disk storage and move around if underlying hardware goes faulty. It is recommended to move BLOB based VHD's to Managed Disks.

Query

Tables used in this query:

• azure_compute_virtual_machine_scale_set
• azure_subscription

Controls using this query:

• Virtual machine scale sets should use managed disks

SQL