turbot/terraform_azure_compliance

Query: compute_vm_automatic_updates_enabled_windows

Usage

powerpipe query terraform_azure_compliance.query.compute_vm_automatic_updates_enabled_windows

Steampipe Tables

SQL

select
address as resource,
case
when not (attributes_std ->> 'enable_automatic_updates')::boolean then 'alarm'
else 'ok'
end status,
split_part(address, '.', 2) || case
when not (attributes_std ->> 'enable_automatic_updates')::boolean then ' automatic updates disabled'
else ' automatic updates enabled'
end || '.' reason
, path || ':' || start_line
from
terraform_resource
where
type in ('azurerm_windows_virtual_machine', 'azurerm_windows_virtual_machine_scale_set');

Controls

The query is being used by the following controls: