turbot/aws_insights

Query: iam_policy_overview

Usage

powerpipe query aws_insights.query.iam_policy_overview

Steampipe Tables

SQL

select
name as "Name",
path as "Path",
create_date as "Create Date",
update_date as "Update Date",
policy_id as "Policy ID",
arn as "ARN",
case is_aws_managed
when true then 'AWS Managed'
else account_id
end as "Account ID"
from
aws_iam_policy
where
arn = $1
limit 1

Dashboards

The query is used in the dashboards: