Exporting a list of users email with GAM

[MigrationWooki]

Hi,

 I've just started using GAM and can see it's a handy tool. I want to use GAM to export a list of all users and all of their email addresses, so far I've got:

"gam print users lastlogintime aliases.csv"

This gives me a list of all aliases and non editable address (aren't they the same thing as aliases?) in a CSV format. What I would like to do is put all of the aliases together in the same field and use a custom delimeter so that when I open Excel it will give me something along the lines of:

primary email, last login, aliases

jo...@gmail.com, never, jo...@gmail2.com;joh...@gmail.com;joh...@gmail.com

Any help on achieving the above is appreciated.

Thanks

[Mark Blair]

Give this a try:

gam print users lastlogintime aliases > aliases.csv

[Andrew Flanagan]

This worked for me,

gam print users firstname lastname > allgoogleusers.csv

This outputs - account email address, surname, fullname,  firstname

Regards

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

Cordant Group PLC (Recruitment Division). 346 Long Lane, Hillingdon, Middlesex, UB10 9PF.
Cordant Group PLC. is a company registered in England and Wales with company registration number: 3385619. 

[Daniel Broersma]

Still new to GAM, trying things out.  The above command gives me the email address, then the first name, and last name, all comma separated, which is expected.  Is there is a way to print out a list of usernames so that I get the firstname lastname put together, then comma separate out the user email address?

[usermo1]

we get the list of all the recipients of all email users. 

Suppose we have 85 users and to date they have sent emails to many recipients. Can we get the list of all those recipients?

[Ross Scroggs]

With Advanced GAM (https://github.com/taers232c/GAMADV-XTD3) you would do the following.

gam redirect csv ./Recipients.csv multiprocess csv users.csv gam user "~email" print messages matchlabel sent headers to

Ross

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/1cb23aec-df70-45ad-9bc8-3fbcb8bf17d0n%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Ross Scroggs]

Here is users.csv:

email

test...@domain.com

test...@domain.com

...

--

Ross Scroggs

ross.s...@gmail.com