"GAM print groups" Last Time Used

[Dale Courtney]

My boss asked that I provide him a list of Groups and members. I successfully ran 

gam print groups name description members > groups.csv

He has asked if there is a way to determine the last time the group was used for sending/receiving an email. 

Is there a GAM command for that? 

Thanks in advance. 

Best,

Dale

[Jay Lee]

There's no API for this so no way for GAM to determine but you can navigate to:

https://groups.google.com/a/jhltechservices.com/forum/#!forumsearch/

and you should see info on last email to listed groups (assuming you have proper permissions to the groups)

Jay Lee

--
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/3e6448ab-083b-4313-a99d-eb03ff02965c%40googlegroups.com.

[Ian Crew]

Also note that Groups can be used for a whole lot more than just emails, like Calendar invitations, permissions in Google Drive/Docs/Sheets/Slides, and so on. So just because an email hasn’t gone to a Group recently, that doesn’t necessarily mean it’s not being used. 

Cheers,

Ian

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BVVBp-EfnH3%2BpNwiMOZtsvV16B1Ca3cQwKEJFxqzHtetkAA%3Dw%40mail.gmail.com.

--

___

Ian Crew

IST-Architecture, Platforms and Integration (API)

Earl Warren Hall, Second Floor

University of California, Berkeley

[Dale Courtney]

Ian, 

Thanks for the response. That makes sense. 

Best,

Dale

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAD2sLFsoOsEZ0z%2BOtRJTAtu%3DfHJ1dwx61AtcdNeN4s8cf1cVbw%40mail.gmail.com.

--

best,

Dale Courtney

IT Manager, Emsi

Dale.C...@EconomicModeling.com

208.882.9993

No one runs untested code on a network server, for the code may crash and take down the server. Likewise, no one puts old format data files into new databases. The new database will be corrupted, and the data will be lost. No, you put new-format data into new databases.
Matt 9:17, IT Translation (ITT)

 

[Bradley Stinson]

One way to go about accomplishing your task is to use BigQuery and get your gmail logs flowing into it. After enough time has elapsed you can write a query to see when the last time mail was sent as or received by the group. I can't remember who (possibly Kim Nillson or Steve @dyntech I think) has a public page with some examples of queries to use for exactly this. Ian makes a very important note about other uses for groups though, if the next part of your task is to perform a cleanup of said groups, this data alone doesn't give you a complete picture of whether or not the group is actually being used for something.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAG56vfP1HBSFa4%2BQAVziU3tVMs0NyzPWU%2BtBXzh938QFD-Ztaw%40mail.gmail.com.

[Dale Courtney]

Brad, 

Thanks for that heads up about BigQuery. I've not even heard of it before. We are a G-Suite corporate customer, so it may be (partially) covered under our license. 

best,
Dale

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAC6ikXFnuky%2B%2B-sFsW%2BSEXZm4F8phR41XO%3DdmfnsAVZ3YTeTwQ%40mail.gmail.com.