turbot/azure_insights

Query: app_service_web_app_ftps_state

Usage

powerpipe query azure_insights.query.app_service_web_app_ftps_state

SQL

select
'FTP' as label,
configuration -> 'properties' ->> 'ftpsState' as value,
case when configuration -> 'properties' ->> 'ftpsState' = 'AllAllowed' then 'alert' else 'ok' end as type
from
azure_app_service_web_app
where
lower(id) = $1;

Dashboards

The query is used in the dashboards: