v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

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_activity_retention 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 guardrails_mod_auto_update guardrails_retention guardrails_workspace_user_activity 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_count

Usage

powerpipe query guardrails_insights.query.guardrails_control_invalid_count

Steampipe Tables

guardrails_control

Turbot Guardrails plugin

SQL

select
  case when count(*) > 0 then count(*) else '0' end as value,
  'Invalid' as label,
  case when count(*) = 0 then 'ok' else 'alert' end as "type"
from
  guardrails_control
where
  state = 'invalid';

Dashboards

The query is used in the dashboards:

Turbot Guardrails Controls Dashboard