turbot/azure_insights

Query: activedirectory_group_age_table

Usage

powerpipe query azure_insights.query.activedirectory_group_age_table

Steampipe Tables

SQL

select
g.display_name as "Display Name",
g.id as "ID",
now() :: date - g.created_date_time :: date as "Age in Days",
g.created_date_time as "Create Time",
g.expiration_date_time as "Expiration Time",
g.renewed_date_time as "Last Renewed Time",
g.tenant_id as "Tenant ID"
from
azuread_group as g
order by
g.created_date_time,
g.display_name;

Dashboards

The query is used in the dashboards: