turbot/guardrails_insights

Query: active_controls_count

Usage

powerpipe query guardrails_insights.query.active_controls_count

Steampipe Tables

SQL

select
sum((output -> 'active_controls' -> 'metadata' -> 'stats' ->> 'total')::int) as "Active Controls"
from
guardrails_query
where
query = '{
active_controls: controls(
filter: "state:active !resourceTypeId:tmod:@turbot/turbot#/resource/types/turbot"
) {
metadata {
stats {
total
}
}
}
}';

Dashboards

The query is used in the dashboards: