turbot/guardrails_insights
GitHub

Query: guardrails_control_invalid_oldest

Usage

steampipe query guardrails_insights.query.guardrails_control_invalid_oldest

Plugins & 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: