turbot/guardrails_insights

Query: resources_count

Usage

powerpipe query guardrails_insights.query.resources_count

Steampipe Tables

SQL

select
sum((output -> 'resources' -> 'metadata' -> 'stats' ->> 'total')::int) as "Resources"
from
guardrails_query
where
query = '{
resources: resources(
filter: "resourceTypeId:tmod:@turbot/aws#/resource/types/aws,tmod:@turbot/azure#/resource/types/azure,tmod:@turbot/gcp#/resource/types/gcp,tmod:@turbot/servicenow#/resource/types/serviceNow,tmod:@turbot/turbot#/resource/types/folder,tmod:@turbot/turbot#/resource/types/file,tmod:@turbot/turbot#/resource/types/smartFolder"
) {
metadata {
stats {
total
}
}
}
}';

Dashboards

The query is used in the dashboards: