Meeting recurring deletion

821 views
Skip to first unread message

issac kelvin

unread,
Mar 6, 2024, 4:18:27 AM3/6/24
to GAM for Google Workspace
Hello 

Is there any gam command in which we can run and delete the calendar event which was created by ex employees.

We dont have meeting event details  but need to perform deletion for around 3706 users.

Thanks
Issac

Brian Kim

unread,
Mar 6, 2024, 10:50:43 AM3/6/24
to GAM for Google Workspace
Do your ex-employees exist? Or have they been deleted? (i.e. are the events orphaned - events without an organizer? or are they organized by group.calendar.google.com?)


Depending on the organizer, you should be able list the events, filter, and then delete.


issac kelvin

unread,
Mar 6, 2024, 8:22:50 PM3/6/24
to GAM for Google Workspace
Hello Brian,

Thanks for the suggestion 

We can see the email id in archive state but we are not sure of event id since there around 3000+ users.

We need to delete the all the events for archived accounts let me know if there is any suggestion .

Thanks
Issac

Robert Fine

unread,
Mar 7, 2024, 5:00:12 AM3/7/24
to GAM for Google Workspace
Hi Issac, 

When an account is archived the Google services like calendar do not work anymore.

so you cant user the account or email adres to delete the calendar so far as i know. 

the only thing i can think of is using the debug calendar to get the event id (https://www.google.com/calendar/render?gsessionid=OK&eventdeb=1)
klik the event then go to troubleshooting info and copy the event id (after = until _)

then to delete the event for all users. gam all users delete event eventid <eventid> doit

Brian Kim

unread,
Mar 7, 2024, 8:15:17 AM3/7/24
to GAM for Google Workspace
You could try doing

# Create events.csv to get all the events in users calendars after today
gam config auto_batch_min 1 redirect csv ./events.csv multiprocess all users print events fields organizer after today

# Once the CSV is generated look in organizer.email column and filter events organized by archived users or events where organizers don't exist
# Save the filtered list as events_to_delete.csv

# Delete the events (For recurring events, all recurrence of the events may be deleted). Personally I don't really care what happens to events in my calendar that's already happened, but further filtering may be needed. Test on a small list of events to make sure it does what you wanted.
gam csv events_to_delete.csv gam user "~primaryEmail" delete events "~id" doit 

Brian Kim

unread,
Mar 7, 2024, 8:17:09 AM3/7/24
to GAM for Google Workspace
correction* 
after today needs to come immediately following print events. 

# Create events.csv to get all the events in users calendars after today
gam config auto_batch_min 1 redirect csv ./events.csv multiprocess all users print events after today fields organizer

issac kelvin

unread,
Mar 7, 2024, 9:41:35 AM3/7/24
to google-ap...@googlegroups.com
Hello 

We have meeting room details we want to delete from 300 meeting rooms and event's that was created by who left the organisation.

--
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/TeWmZ66HSZw/unsubscribe.
To unsubscribe from this group and all its topics, 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/09bf00f3-508e-4f25-b2ee-32af62c4056en%40googlegroups.com.

Brian Kim

unread,
Mar 7, 2024, 2:54:01 PM3/7/24
to google-ap...@googlegroups.com
In that case, create resources.csv first.

gam redirect csv ./resources.csv print resources

# Create events.csv to get all the events in resource calendars after today.
gam config auto_batch_min 1 redirect csv ./events.csv multiprocess csv resources.csv gam calendar "~resourceEmail" print events after today fields organizer


issac kelvin

unread,
Mar 7, 2024, 8:17:32 PM3/7/24
to google-ap...@googlegroups.com
Hello 

There are around 1700 resources .

We know the resource  name can we delete only the meeting invite which  was created by user who had left the organisation 

Thanks
Issac 

Brian Kim

unread,
Mar 7, 2024, 8:25:23 PM3/7/24
to google-ap...@googlegroups.com
Once resource.csv is created you can filter it down to just the resources you want to wipe events from.

issac kelvin

unread,
Mar 7, 2024, 8:30:38 PM3/7/24
to google-ap...@googlegroups.com
Hello 

How to create those resource.csv


Brian Kim

unread,
Mar 8, 2024, 2:33:29 PM3/8/24
to GAM for Google Workspace

issac kelvin

unread,
Mar 10, 2024, 9:59:42 PM3/10/24
to google-ap...@googlegroups.com
Hello 

We got around like 1708 resources let me know how to know which meetings where scheduled by user who has left organisation.



On Sat, 9 Mar 2024, 01:03 Brian Kim, <the.br...@gmail.com> wrote:
gam redirect csv ./resources.csv print resources

--
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/TeWmZ66HSZw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.

Brian Kim

unread,
Mar 10, 2024, 10:03:55 PM3/10/24
to GAM for Google Workspace
Print the events in the resource calendars and look at the organizer column and filter it as I mentioned before.

Reply all
Reply to author
Forward
0 new messages