Azure Active Directory Group Age ReportAzure Active Directory Group DashboardAzure Active Directory Group DetailAzure Active Directory User Age ReportAzure Active Directory User DashboardAzure Active Directory User DetailAzure App Service Web App DashboardAzure App Service Web App DetailAzure Compute Disk Age ReportAzure Compute Disk DashboardAzure Compute Disk DetailAzure Compute Disk Encryption ReportAzure Compute Snapshot Age ReportAzure Compute Snapshot DashboardAzure Compute Snapshot DetailAzure Compute Virtual Machine DashboardAzure Compute Virtual Machine DetailAzure Compute Virtual Machine Scale Set DashboardAzure Compute Virtual Machine Scale Set DetailAzure Compute Virtual Machine Scale Set VM DetailAzure CosmosDB Account DashboardAzure CosmosDB Account DetailAzure CosmosDB Account Encryption ReportAzure CosmosDB Mongo Database DetailAzure Key Vault DashboardAzure Key Vault DetailAzure Key Vault Key Age ReportAzure Key Vault Key DashboardAzure Key Vault Key DetailAzure Kubernetes Cluster DashboardAzure Kubernetes Cluster DetailAzure Network Express Route Circuit DashboardAzure Network Express Route Circuit DetailAzure Network Firewall DetailAzure Network Interface DetailAzure Network Load Balancer DetailAzure Network Public IP DetailAzure Network Security Group DashboardAzure Network Security Group DetailAzure Network Subnet DetailAzure SQL Database Age ReportAzure SQL Database DashboardAzure SQL Database DetailAzure SQL Server DashboardAzure SQL Server DetailAzure SQL Server Encryption ReportAzure Storage Account Age ReportAzure Storage Account DashboardAzure Storage Account DetailAzure Subscription ReportAzure Virtual Network DashboardAzure Virtual Network Detail
Dashboard: Azure App Service Web App Detail
This dashboard answers the following questions for each SQL server:
- How is the web app configured?
- What relationships does the web app have with other resources?
- How is the web app diagnostic configured?
- What tags are applied?
- Are HTTPS and HTTP logging enabled?
- What FTP and TLS versions are configured?
This dashboard contains 6 cards, 1 graph, 1 input and 5 tables.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-azure-insightsStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select Azure App Service Web App Detail dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run azure_insights.dashboard.app_service_web_app_detail --shareQueries
This dashboard uses the the following queries:
select configuration -> 'properties' ->> 'loadBalancing' as "Load Balancing", configuration -> 'properties' ->> 'linuxFxVersion' as "Linux App Framework and version", configuration -> 'properties' ->> 'numberOfWorkers' as "Workers", configuration -> 'properties' ->> 'preWarmedInstanceCount' as "Pre-warmed Instances", case when (configuration -> 'properties' ->> 'alwaysOn')::boolean then 'Enabled' else 'Disabled' end as "Always On", case when (configuration -> 'properties' ->> 'autoHealEnabled')::boolean then 'Enabled' else 'Disabled' end as "Auto Heal", case when (configuration -> 'properties' ->> 'detailedErrorLoggingEnabled')::boolean then 'Enabled' else 'Disabled' end as "Detailed Error Logging", case when (configuration -> 'properties' ->> 'http20Enabled')::boolean then 'Enabled' else 'Disabled' end as "HTTP 20", case when (configuration -> 'properties' ->> 'httpLoggingEnabled')::boolean then 'Enabled' else 'Disabled' end as "HTTP Logging", case when (configuration -> 'properties' ->> 'localMySqlEnabled')::boolean then 'Enabled' else 'Disabled' end as "Local MySQL", configuration -> 'properties' ->> 'logsDirectorySizeLimit' as "HTTP Logs Directory Size Limit", configuration -> 'properties' ->> 'managedPipelineMode' as "Managed Pipeline Mode", case when (configuration -> 'properties' ->> 'remoteDebuggingEnabled')::boolean then 'Enabled' else 'Disabled' end as "Remote Debugging", case when (configuration -> 'properties' ->> 'requestTracingEnabled')::boolean then 'Enabled' else 'Disabled' end as "Request Tracing"from azure_app_service_web_appwhere lower(id) = $1;