turbot/steampipe-mod-azure-insights

Dashboard: Azure SQL Server Detail

This dashboard answers the following questions for each SQL server:

  • How is the server configured?
  • What relationships does the SQL server have with other resources?
  • What tags are applied?
  • How is encryption configured?
  • Is vulnerability assessment enabled?
  • What audit policies, virtual network rules are configured?
  • How is the private endpoint configured?
This dashboard contains 6 cards, 1 graph, 1 input and 8 tables.

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 Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
'Azure AD Authentication' as label,
case when server_azure_ad_administrator is not null then 'Enabled' else 'Disabled' end as value,
case when server_azure_ad_administrator is not null then 'ok' else 'alert' end as type
from
azure_sql_server
where
lower(id) = $1
and subscription_id = split_part($1, '/', 3);

Tags