Query: Access key count by user name

Description

Determine the number of access keys associated with each user in your AWS IAM service. This can be useful for understanding how access is distributed across your users, potentially highlighting areas where access can be consolidated or better managed.

Query

Tables used in this query:

• aws_iam_access_key

SQL