turbot/steampipe-mod-aws-insights

Query: iam_user_inventory_table

Usage

powerpipe query aws_insights.query.iam_user_inventory_table

Steampipe Tables

SQL

select
u.name as "Name",
u.create_date as "Create Date",
u.mfa_enabled as "MFA Enabled",
u.password_last_used as "Password Last Used",
u.tags as "Tags",
u.arn as "ARN",
u.account_id as "Account ID",
a.title as "Account"
from
aws_iam_user as u
left join aws_account as a on u.account_id = a.account_id
order by
u.name;

Dashboards

The query is used in the dashboards: