Query: appservice_web_app_worker_more_than_one

select
  p ->> 'ID' as resource,
  case
    when (p -> 'SiteProperties' -> 'siteConfig' ->> 'numberOfWorkers')::int > 1 then 'ok'
    else 'alarm'
  end as status,
    a.name || ' has ' || (p -> 'SiteProperties' -> 'siteConfig' ->> 'numberOfWorkers') || ' no of worker(s).' as reason
  
  , a.resource_group as resource_group
  , sub.display_name as subscription
from
  azure_app_service_plan as a,
  jsonb_array_elements(apps) as p,
  azure_subscription as sub
where
  sub.subscription_id = a.subscription_id;