AWS CLI Single query

Question

This query gets username and groupname. How do I get all details of a user (aws list iam-users) like 
username, createdate, passwordlastused, & groupname ? I tried to fetch other fields --query 'Users[].[UserName,CreateDate]' but it throws an error.

```
users="$(aws iam list-users --query 'Users[].UserName' --output text)"
for user in $users ; do
  groups="$(aws iam list-groups-for-user \
      --user-name $user \
      --query 'Groups[].GroupName' \
      --output text \
    | paste -s -d, -  
  )"
  printf "%s	%s
" "$user" "$groups"
done
```

Gary Mclean · Accepted Answer

Ok, spent 30 mins on this for you... This works but needs JQ installed...

You can tweak as needed, but it outputs the users details and their groups. Let me know if this is what your looking for.. We can adjust where needed. I outputted as a CSV format so you can output to a file and import into a CSV viewer if needed

I may keep this one in my script archive :-)

```
#!/bin/bash
users=$(aws iam list-users --query 'Users[*]' --output json)

Output Example

```
GaryUser1,JJLYGGYLGY59565787785,arn:aws:iam::123456789123:user/GaryUser1,2021-05-17T16:32:39Z,2023-05-17T16:32:39Z,group1,group2,group3
```

Columns:-
UserName, UserId, Arn, CreateDate, PasswordLastUsed, GROUPS

**Please accept this as the answer if this solves your question. This helps me and others..**

Gary

Gary Mclean · Answer

List your fields as follows

```
aws iam list-users --query 'Users[*].[UserName, CreateDate, UserId]'
```

If you recieve this error:-

`Bad value for --query 'Users[*].[UserName,: Bad jmespath expression: Unclosed ' delimiter:
'Users[*].[UserName,
^`

Then use double quotes. Makes a difference Windows vs Linux

```
aws iam list-users --query "Users[*].[UserName, CreateDate, UserId]"
```

As for your script, try this

```
users=$(aws iam list-users --query 'Users[*].[UserName, CreateDate, UserId]'  --output text)
```

Gary

AWS CLI Single query

Relevant content