turbot/guardrails_insights

Query: guardrails_control_invalid_24_hours_count

Usage

powerpipe query guardrails_insights.query.guardrails_control_invalid_24_hours_count

Steampipe Tables

SQL

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

Dashboards

The query is used in the dashboards: