turbot/guardrails_insights

Query: guardrails_control_invalid_after_1_year

Usage

powerpipe query guardrails_insights.query.guardrails_control_invalid_after_1_year

Steampipe Tables

SQL

with after_1_year as
(
select
now()::date - update_timestamp::date as days
from
guardrails_control
where
update_timestamp <= now() - '1 year' :: interval
and state = 'invalid'
)
select
count(*) as value,
'> 1 Year' as label
from
after_1_year;

Dashboards

The query is used in the dashboards: