turbot/tailpipe-mod-azure-activity-log-detections

Query: Logs by Resource Group

Usage

powerpipe query azure_activity_log_detections.query.activity_dashboard_logs_by_resource_group

Tailpipe Tables

SQL

select
resource_group_name as "Resource Group",
count(*) as "Logs"
from
azure_activity_log
where
resource_group_name is not null
group by
resource_group_name
order by
count(*) desc
limit 10;

Dashboards

The query is used in the dashboards: