Query: compute_virtual_machine_guest_configuration_assignments

select
  g ->> 'name' as "Name",
  g ->> 'complianceStatus' as "Compliance Status",
  g -> 'guestConfiguration' -> 'configurationSetting' ->> 'allowModuleOverwrite' as "Allow Module Overwrite",
  g -> 'guestConfiguration' -> 'configurationSetting' ->> 'configurationMode' as "Configuration Mode",
  g -> 'guestConfiguration' -> 'configurationSetting' ->> 'configurationModeFrequencyMins' as "Configuration Mode Frequency Mins",
  (g -> 'guestConfiguration' -> 'configurationSetting' ->> 'rebootIfNeeded')::boolean as "Reboot if Needed",
  g -> 'guestConfiguration' -> 'configurationSetting' ->> 'refreshFrequencyMins' as "Refresh Frequency Mins",
  g -> 'guestConfiguration' ->> 'version' as "Version"
from
  azure_compute_virtual_machine,
  jsonb_array_elements(guest_configuration_assignments) as g
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);