turbot/tailpipe-mod-github-security-log-detections

Query: Integration Activity

Description

Summarizes security log events grouped by integration, including total events, unique users, and last activity.

Usage

powerpipe query github_security_log_detections.query.activity_dashboard_integration_summary

Tailpipe Tables

SQL

select
integration,
count(*) as total_events
from
github_security_log
where
integration IS NOT NULL
group by
integration
order by
total_events DESC;

Dashboards

The query is used in the dashboards: