turbot/aws_insights

Query: iam_policy_attached

Usage

powerpipe query aws_insights.query.iam_policy_attached

Steampipe Tables

SQL

select
case when is_attached then 'Attached' else 'Detached' end as value,
'Attachment Status' as label,
case when is_attached then 'ok' else 'alert' end as type
from
aws_iam_policy
where
arn = $1;

Dashboards

The query is used in the dashboards: