Query: compute_vm_guest_configuration_installed

with all_vm as (
  select
  *
  from
    terraform_resource
  where
    type = 'azurerm_virtual_machine'
), 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_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_vm as c
  left join vm_guest_configuration as d on c.name = d.vm_name;