turbot/aws_insights

Query: eventbridge_rule_targets

Usage

powerpipe query aws_insights.query.eventbridge_rule_targets

Steampipe Tables

SQL

select
target ->> 'Id' as "ID",
target ->> 'Arn' as "ARN",
target ->> 'Input' as "Input"
from
aws_eventbridge_rule as c,
jsonb_array_elements(c.targets) as target
where
c.arn = $1
and c.account_id = split_part($1, ':', 5)
and c.region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: