turbot/steampipe-mod-guardrails-insights

Control: Turbot > Mod > Health

Description

Workspaces Mod health summary.

Usage

Run the control in your terminal:

powerpipe control run guardrails_insights.control.mod_health

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run guardrails_insights.control.mod_health --share

SQL

This control uses a named query:

select
split_part(resource_trunk_title, '>', 2) as resource,
case
when state in ('tbd', 'invalid') then 'info'
else state
end as status,
case
when state = 'ok' then split_part(resource_trunk_title, '>', 2) || ' is healthy.'
else split_part(resource_trunk_title, '>', 2) || ' ' || reason || '.'
end as reason
, split_part(workspace, '//', 2) as workspace
from
guardrails_control
where
control_type_uri = 'tmod:@turbot/turbot#/control/types/modHealth'
group by
workspace, id, state, resource_trunk_title, reason
order by
workspace;