turbot/terraform_azure_compliance

Query: compute_vm_guest_configuration_installed_windows

Usage

powerpipe query terraform_azure_compliance.query.compute_vm_guest_configuration_installed_windows

Steampipe Tables

SQL

with all_windows_vm as (
select
*
from
terraform_resource
where
type = 'azurerm_virtual_machine'
and (attributes_std -> 'os_profile_windows_config') is not null
), vm_extensions as (
select
*
from
terraform_resource
where
type = 'azurerm_virtual_machine_extension'
),
vm_guest_configuration as (
select
split_part((b.attributes_std ->> 'virtual_machine_id'), '.', 2) as vm_name
from
all_windows_vm as a
left join vm_extensions as b on (split_part((b.attributes_std ->> 'virtual_machine_id'), '.', 2)) = a.name
where
(b.attributes_std ->> 'publisher') = 'Microsoft.GuestConfiguration'
)
select
address as resource,
case
when d.vm_name is null then 'alarm'
else 'ok'
end as status,
split_part(address, '.', 2) || case
when d.vm_name is null then ' have guest configuration extension not installed'
else ' have guest configuration extension installed'
end || '.' reason
, path || ':' || start_line
from
all_windows_vm as c
left join vm_guest_configuration as d on c.name = d.vm_name;

Controls

The query is being used by the following controls: