Control: System updates should be installed on your machines

Description

Missing security system updates on your servers will be monitored by Azure Security Center as recommendations.

Usage

Run the control in your terminal:

powerpipe control run terraform_azure_compliance.control.compute_vm_system_updates_installed

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run terraform_azure_compliance.control.compute_vm_system_updates_installed --share

SQL

This control uses a named query:

select
  address as resource,
  case
    when (attributes_std -> 'os_profile_windows_config' ->> 'enable_automatic_upgrades')::boolean then 'ok'
    else 'alarm'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std -> 'os_profile_windows_config' ->> 'enable_automatic_upgrades')::boolean then ' automatic system updates enabled'
    else ' automatic system updates disabled'
  end || '.' reason
  
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'azurerm_virtual_machine';

Control: System updates should be installed on your machines

Description

Usage

SQL

Tags