turbot/guardrails_insights

Query: guardrails_control_invalid_oldest

Usage

powerpipe query guardrails_insights.query.guardrails_control_invalid_oldest

Steampipe Tables

SQL

select
id,
workspace,
control_type_trunk_title as "Control Title",
resource_trunk_title as "Resource Trunk Title",
now()::date - update_timestamp::date as "Age in Days",
_ctx ->> 'connection_name' as "Connection Name"
from
guardrails_control
where
state = 'invalid'
order by
"Age in Days" desc;

Dashboards

The query is used in the dashboards: