🚀Launch Week 05, July 22nd - 26th, 2024🚀

Plugins Docs Home

turbot/guardrails_insights

accounts_by_provider accounts_by_workspace accounts_count accounts_total active_controls_by_workspace active_controls_count alerts_total cache_health_check controls_summary guardrails_control_alarm_count guardrails_control_alarm_total_count guardrails_control_alert_24_hours_count guardrails_control_alert_after_1_year guardrails_control_alert_between_1_30_days guardrails_control_alert_between_30_90_days guardrails_control_alert_between_90_365_days guardrails_control_alert_oldest guardrails_control_error_24_hours_count guardrails_control_error_after_1_year guardrails_control_error_between_1_30_days guardrails_control_error_between_30_90_days guardrails_control_error_between_90_365_days guardrails_control_error_count guardrails_control_error_oldest guardrails_control_error_total_count guardrails_control_invalid_24_hours_count guardrails_control_invalid_after_1_year guardrails_control_invalid_between_1_30_days guardrails_control_invalid_between_30_90_days guardrails_control_invalid_between_90_365_days guardrails_control_invalid_count guardrails_control_invalid_oldest guardrails_control_invalid_total_count guardrails_control_top_20_alerts installed_aws_mods_count installed_azure_mods_count installed_gcp_mods_count installed_mods_by_platform mod_auto_update mod_health_benchmark mod_installed_controls_error mod_installed_controls_error_list mod_process_monitor_benchmark policies_summary policy_settings_total resources_by_workspace resources_count smart_process_retention smart_retention stacks_aggregate type_installed_controls_error type_installed_controls_error_list workspace_account_detail workspace_health_control workspace_stats workspaces_count

Query: guardrails_control_invalid_total_count

Usage

powerpipe query guardrails_insights.query.guardrails_control_invalid_total_count

Steampipe Tables

guardrails_control

Turbot Guardrails plugin

SQL

select
  count(*) as value,
  'Count' as label 
from
  guardrails_control 
where
  state = 'invalid';

Dashboards

The query is used in the dashboards:

Turbot Guardrails Controls Invalid Age Report