Google Group Usage

[Jeffrey Reid]

Howdy.

I am trying to report on ~500 groups when they last received an email.

I tried 

gam group xxxx-5...@xxx.k12.or.us print messages max_to_print 1 >> grouplastemail.csv

but found I was actually getting the last email for each user in the group, not the emails that went to the group.

I'm hoping to find obsolete/unused groups so I can clean them up and not have ~500 groups in the future. :(

Any thoughts are appreciated.

[Ross Scroggs]

This is not easy, try the following that only shows messages sent to the group:

gam group xxxx-5...@xxx.k12.or.us print messages query "list:xxxx-5...@xxx.k12.or.us" max_to_print 1 >> grouplastemail.csv

Send me  private Meet/Zoom invitation if you'd like to discuss.

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 visit https://groups.google.com/d/msgid/google-apps-manager/8f5a8f03-cfad-4be8-98a3-c333a7bc80d6n%40googlegroups.com.

[Jeffrey Reid]

That's seems to have done the trick and makes sense.

Thanks so much for the help!

You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/aCRcTTziE50/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/8113E063-0590-48A1-B5DA-A5A35824930D%40gmail.com.

--

Jeffrey Reid

503-565-4081

Network Systems Analyst

[Ross Scroggs]

If you have a CSV file Groups.csv with column email:

gam config num_threads 10 redirect csv ./grouplastemail.csv multiprocess redirect stderr - multiprocess csv Groups.csv gam group "~email" print messages query "list:~~email~~" max_to_print 1

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/CAH6JwJBOXM4Y6v6ELSsAVJ1pHqE8h%3DMAfgoqpUMhZFFdMhGqsQ%40mail.gmail.com.