List users and roles of all projects in csv for Google Cloud

list-users.bash

#!/bin/bash

outfile="./iam-policy.csv"

echo "Project, Account, Role" > $outfile
for project in $(gcloud projects list --format="table(projectId)" --filter 'parent.id=... AND parent.type=organization' | tail -n +2 | cut -f2 -d$' ' |  sed '/^$/d'); do
    out=$(gcloud projects get-iam-policy $project --flatten="bindings[].members[]" --format="csv[no-heading](bindings.members,bindings.role)")
    echo $project
    for line in $out; do
      echo "$project,$line" >> $outfile
    done
done