search

taers232c / GAMADV-XTD3

Command line tool to manage Google Workspace
687 stars 86 forks source link

Delete chatspaces with no activity last 90 days #380

Closed geirhl closed 3 weeks ago

geirhl commented 8 months ago

Hi We have 26000 chatspaces and no activity in 25000 of them for the last 90 days. Is there a way to delete these 25000 with GAMADV-XTD3? In Google admin GUI its possible to use a filter "Days without activity". But there is no way to export that list to a csv file I can use with the GAM delete chatspace command.

In GAMADV-XTD3 it is possible to list all chatspaces for all users to a csv file, but not with a filter "90 days without activity".

I also want to delete all chatspaces without members, and finally all chatspaces with external members

I will be very grateful if someone can help me with commands to solve the challenge. Otherwise, I have to delete each room manually in Google Admin GUI.

das1 commented 8 months ago

Try using the table scrape extension in chrome with the admin GUI to create a csv that you can then use with GAM. I've successfully used it to export a list of 11,800 shared drives to export storage usage.

https://chrome.google.com/webstore/detail/table-scrape/ocglnchcpdjocppfepejjddgieoodaep

-- Dan Schwartz | LTS - Systems Engineering | Lehigh University | @.*** | 610-758-5061

On Mon, Oct 16, 2023 at 7:22 AM geirhl @.***> wrote:

Hi We have 26000 chatspaces and no activity in 25000 of them for the last 90 days. Is there a way to delete these 25000 with GAMADV-XTD3? In Google admin GUI its possible to use a filter "Days without activity". But there is no way to export that list to a csv file I can use with the GAM delete chatspace command.

In GAMADV-XTD3 it is possible to list all chatspaces for all users to a csv file, but not with a filter "90 days without activity".

I also want to delete all chatspaces without members, and finally all chatspaces with external members

I will be very grateful if someone can help me with commands to solve the challenge. Otherwise, I have to delete each room manually in Google Admin GUI.

— Reply to this email directly, view it on GitHub https://github.com/taers232c/GAMADV-XTD3/issues/380, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA5X6DLTIONLM6HCR4AC3XDX7UKIVAVCNFSM6AAAAAA6CAXSLCVHI2DSMVQWIX3LMV43ASLTON2WKOZRHE2DIOJYGQ3TOMA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

taers232c commented 8 months ago

As the API stands now, screen scraping is your best bet.

Ross

Ross Scroggs @.***

On Oct 16, 2023, at 4:33 AM, das1 @.***> wrote:

Try using the table scrape extension in chrome with the admin GUI to create a csv that you can then use with GAM. I've successfully used it to export a list of 11,800 shared drives to export storage usage.

https://chrome.google.com/webstore/detail/table-scrape/ocglnchcpdjocppfepejjddgieoodaep

-- Dan Schwartz | LTS - Systems Engineering | Lehigh University | @.*** | 610-758-5061

On Mon, Oct 16, 2023 at 7:22 AM geirhl @.***> wrote:

Hi We have 26000 chatspaces and no activity in 25000 of them for the last 90 days. Is there a way to delete these 25000 with GAMADV-XTD3? In Google admin GUI its possible to use a filter "Days without activity". But there is no way to export that list to a csv file I can use with the GAM delete chatspace command.

In GAMADV-XTD3 it is possible to list all chatspaces for all users to a csv file, but not with a filter "90 days without activity".

I also want to delete all chatspaces without members, and finally all chatspaces with external members

I will be very grateful if someone can help me with commands to solve the challenge. Otherwise, I have to delete each room manually in Google Admin GUI.

— Reply to this email directly, view it on GitHub https://github.com/taers232c/GAMADV-XTD3/issues/380, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA5X6DLTIONLM6HCR4AC3XDX7UKIVAVCNFSM6AAAAAA6CAXSLCVHI2DSMVQWIX3LMV43ASLTON2WKOZRHE2DIOJYGQ3TOMA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/taers232c/GAMADV-XTD3/issues/380#issuecomment-1764275398, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACCTYL7KDYEOI7MWCUKGGTDX7ULQ3AVCNFSM6AAAAAA6CAXSLCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONRUGI3TKMZZHA. You are receiving this because you are subscribed to this thread.