turbot/azure_insights

Query: sql_server_ad_authentication_status

Usage

powerpipe query azure_insights.query.sql_server_ad_authentication_status

Steampipe Tables

SQL

select
ad_authentication,
count(*)
from
(
select
case
when server_azure_ad_administrator is null then 'disabled'
else 'enabled'
end ad_authentication
from
azure_sql_server
) as s
group by
ad_authentication
order by
ad_authentication;

Dashboards

The query is used in the dashboards: