turbot/guardrails_insights

Query: installed_mods_by_platform

Usage

powerpipe query guardrails_insights.query.installed_mods_by_platform

Steampipe Tables

SQL

select
case
when title like '@turbot/aws%' then 'AWS'
when title like '@turbot/azure%' then 'Azure'
when title like '@turbot/gcp%' then 'GCP'
else 'Others'
end as "Mod_Platform",
count(title)
from
guardrails_resource
where
resource_type_uri = 'tmod:@turbot/turbot#/resource/types/mod'
group by
"Mod_Platform";

Dashboards

The query is used in the dashboards: