GAMADV-XTD3 Report IMAP & POP

[Fatneck]

Goal: Get a list of all users who have used IMAP or POP to send an email in the past 30 days.

I am aware of the following commands:

30 Day Users
gam report domain fields gmail:num_30day_imap_users

gam report domain fields gmail:num_30day_pop_users

This displays the raw number of users that meet this criteria.

I would like to run a command, possibly a print command to get an exported .csv file that contains the user account information for all users who have used IMAP or POP to send an email in the past 30 days.

Thanks! 

[Ross Scroggs]

gam config csv_output_row_filter_mode anymatch csv_output_row_filter "'gmail.last_imap_time:regex:^.+$','gmail.last_pop_time:regex:^.+$'" report users fields gmail:last_imap_time,gmail:last_pop_time date -2d nodatechange 

Ross

----

Ross Scroggs

Ross.S...@gmail.com

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" 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/fd99afa0-c837-4785-b206-1a96aca0148an%40googlegroups.com.

[James SEYMOUR]

I cannot test this as we have IMAP/POP disabled but this should work if you want to run against an OU (and sub-OUs). The todrive option will create a Google Sheet of the results, but change if you want to pipe to a CSV. This will list the users and whether POP or IMAP is enabled or disabled. More info here https://github.com/taers232c/GAMADV-XTD3/wiki/Users-Gmail-Settings

gam ou_and_children_ns </Path/To/OU> print imap todrive

[Fatneck]

These results appear to be the droids I am looking for. Thank you for your prompt replies!