You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This is a feature request to add ability to query iam user access key ids and group by count. I would like to be able to see which iam users have more than 1 access key ids. Not sure if this query would be correct but I am looking for something close to this.
This is a feature request to add ability to query iam user access key ids and group by count. I would like to be able to see which iam users have more than 1 access key ids. Not sure if this query would be correct but I am looking for something close to this.
SELECT
resourceId,
resourceName,
resourceType,
resourceCreationTime,
tags,
configuration.accessKeyId
COUNT(*)
WHERE
resourceType = 'AWS::IAM::User'
GROUPBY
configuration.accessKeyId
The text was updated successfully, but these errors were encountered: