Extract csv file with a list of active users and which AWS SSO role they have in Gsuite

[Mariano Schesak]

Hi team,

Good morning how are you? I would need your expertise please because I am needing to obtain an excel file or csv file to review all my active users in Gsuite, and for each user we have a  custom map field named AWS SSO.

I need to extract a file with each of the Gmail users and all the roles they have in that AWS SSO custom attribute.

Sometimes I noticed one users will have 3 or 4 different roles in the AWS SSO custom attribute.

Any advise please of how I could achieve this in GAM just for the active users?

Thank you all.

Regards,

Mariano.

[Mariano Schesak]

Also, perhaps there is a way I could search all the active users in Gsuite, where they have the role of administrator on the custom attribute named AWS SSO.

And the same for other AWS we could have.

Thank you.

Regards,

Mariano.

[Mariano Schesak]

Hi team,

Sorry I believe I found the answer in a past post I made in 2024 where you helped me out.

gam config csv_output_row_filter "customSchemas.AWS-SSO.role.0.value:regex:^.+$" redirect csv ./UsersWithAWS-SSO.csv all users print users fields name custom AWS-SSO

That one did the trick, now I need to consolidate the info appropriately.

Thank you.

Regards,

Mariano.