turbot/azure_insights

Dashboard: Azure SQL Server Dashboard

This dashboard answers the following questions:

  • How many servers are in each subscription, resource group and region?
  • How many publicly accessible servers are there?
  • How many servers have auditing, vulnerability assessment and AD authentication disabled?
This dashboard contains 5 cards.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-azure-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select Azure SQL Server Dashboard dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run azure_insights.dashboard.sql_server_dashboard --share

Queries

The dashboard uses the named queries:

Tags