Google group audit

224 views
Skip to first unread message

Andrea Barone

unread,
Apr 16, 2024, 11:49:03 AM4/16/24
to google-ap...@googlegroups.com
Hello everyone!

I am sure that this one is going to be fun:

Do you know if there is a way for us to audit our Google Groups?

I would like to be able to find out:

all google groups, all their members and their level/role, all their settings (accept email from outside, only internal members, etc..) and finally when was the last activity reported on the group and the email address that caused that activity.

Any suggestions?

Thanks


Andrea Barone

Kings County Office of Education
LAN Manager
Office Phone: (559) 589-7090
Cell-phone: (559) 387-6360


KINGS COUNTY OFFICE OF EDUCATION 
E-MAIL CONFIDENTIALITY NOTICE: 

This e-mail communication and any attachments, including documents, files, or previous e-mail messages, constitute electronic communications within the scope of the Electronic Communications Privacy Act, 18 U.S.C. 2510 et seq. This e-mail communication may contain non-public, confidential or legally privileged information intended for the sole use of the designated recipient(s). The unauthorized and intentional interception, use, copy or disclosure of such information, or attempt to do so, is strictly prohibited and may be unlawful under applicable laws. [18 U.S.C. 2511.] If you have received this e-mail in error, please immediately notify the sender by return e-mail and delete the original e-mail from your system.

Ross Scroggs

unread,
Apr 16, 2024, 11:58:05 AM4/16/24
to google-ap...@googlegroups.com

" when was the last activity reported on the group and the email address that caused that activity"
This isn't available via the API as far as I know.

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

Ross
----
Ross Scroggs



--
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/CAOHUkquj7PG6c86sw%2B_aC%2BW7g0jWU13HrRyyZ6r%3Drg_uzrjKjg%40mail.gmail.com.

Andrea Barone

unread,
Apr 16, 2024, 12:03:46 PM4/16/24
to google-ap...@googlegroups.com
Hey Ross,

thanks for the quick response,

Ultimately I am trying to figure out a way to establish if any google groups are dead due to lack of active users on it (people left and groups were not deleted) and if they are still needed/necessary...do you have any idea for that?

We don't limit staff from creating groups and I think they are creeping but in order to clean them up, we would have to find some sort of a metric to establish their existence.

Any suggestion will be highly appreciated 

Andrea Barone

Kings County Office of Education
LAN Manager
Office Phone: (559) 589-7090
Cell-phone: (559) 387-6360


To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/6DEED7C4-72DD-4EC3-91BA-F614969E805D%40gmail.com.

Ross Scroggs

unread,
Apr 16, 2024, 12:21:10 PM4/16/24
to google-ap...@googlegroups.com
This has been asked many times and there is no good answer.

Some groups, security groups for instance, have no activity but they are important.

Ross
----
Ross Scroggs


Andrea Barone

unread,
Apr 16, 2024, 12:43:06 PM4/16/24
to google-ap...@googlegroups.com
We have GWE+ which it has a lot tools for auditing but not much for Google Groups.

We are aware of the groups that we need as those are configured usually by the IT department but mail list created by staff has been challenging to trace down.


Andrea Barone

Kings County Office of Education
LAN Manager
Office Phone: (559) 589-7090
Cell-phone: (559) 387-6360


To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/AD0B5B56-99AB-428A-A3E2-0435974F0627%40gmail.com.

Ross Scroggs

unread,
Apr 16, 2024, 1:23:50 PM4/16/24
to google-ap...@googlegroups.com
What does this give you: gam report groups event create_group

Ross
----
Ross Scroggs


Andrea Barone

unread,
Apr 16, 2024, 2:39:03 PM4/16/24
to google-ap...@googlegroups.com
I got the following:

name,actor.callerType,actor.email,actor.profileId,group_email,id.applicationName,id.customerId,id.time,id.uniqueQualifier,ownerDomain,type

24 events but it does not seem to display the complete list of groups.

I would imagine that if there is a way to gain all groups' email, we should be able to run a query toward those email addresses and see when was the last email sent/received by it.

Again...I am getting creative here 😂

Andrea Barone

Kings County Office of Education
LAN Manager
Office Phone: (559) 589-7090
Cell-phone: (559) 387-6360


To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/790969D4-51D2-4293-A786-6342894F8C58%40gmail.com.

Ross Scroggs

unread,
Apr 16, 2024, 3:03:23 PM4/16/24
to google-ap...@googlegroups.com
report logs only go back 180 days

I would imagine that if there is a way to gain all groups' email, we should be able to run a query toward those email addresses and see when was the last email sent/received by it.

There are no APIs to get this, maybe this can be gotten with Big Query but others in the group will have to verify/confirm thta.

Ross
----
Ross Scroggs


Reply all
Reply to author
Forward
0 new messages