Query: appservice_ftp_deployment_disabled

select
    fa.id as resource,
    case
      when configuration -> 'properties' ->> 'ftpsState' = 'AllAllowed' then 'alarm'
      else 'ok'
    end as status,
    case
      when configuration -> 'properties' ->> 'ftpsState' = 'AllAllowed' then name || ' FTP deployments enabled.'
      else name || ' FTP deployments disabled.'
    end as reason
  
  , fa.resource_group as resource_group
  , sub.display_name as subscription
  from
    azure_app_service_function_app fa,
    azure_subscription sub
  where
    sub.subscription_id = fa.subscription_id
union
  select
    wa.id as resource,
    case
      when configuration -> 'properties' ->> 'ftpsState' = 'AllAllowed' then 'alarm'
      else 'ok'
    end as status,
    case
      when configuration -> 'properties' ->> 'ftpsState' = 'AllAllowed' then name || ' FTP deployments enabled.'
      else name || ' FTP deployments disabled.'
    end as reason
  
  , wa.resource_group as resource_group
  , sub.display_name as subscription
  from
    azure_app_service_web_app as wa,
    azure_subscription as sub
  where
    sub.subscription_id = wa.subscription_id;