turbot/steampipe-mod-azure-insights

Dashboard: Azure SQL Server Inventory Report

This report answers the following questions:

  • How many SQL servers are there across my subscriptions?
  • What is the state and version of each server?
  • Which servers have public network access enabled?
  • What TLS version is configured for each server?
  • How many firewall and virtual network rules are configured?
  • What are the administrator logins for each server?
  • How are servers distributed across subscriptions, resource groups, and regions?

The inventory report includes:

  • Total count of SQL servers
  • Detailed list of all servers with:
    • Server name and state
    • Version and administrator information
    • Security settings (TLS version, public access)
    • Network configuration (firewall rules, virtual network rules)
    • Resource organization (subscription, resource group, region)
    • Associated tags
This dashboard contains 1 card and 1 table.

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 Inventory Report dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select count(*) as "Servers" from azure_sql_server;

Tags