Export Shared Drive Creators

[Thomas Prescott]

All -

I'm wondering if there's a way to export/print/view Shared Drive creators via GAM. I'm able to see every other type of membership (manager, fileorganizer, etc.) - but "creator" seems to be missing. Here's what Google had to say regarding the subject:


"You can export this information into a CSV file by going to the Drive Audit Log and use the Event filter and choosing Create. After that you can choose the item type to be Shared Drive. After this has been done, click Export (it should be located on the top right). You can choose to export the current columns into a CSV files.

Please keep in mind that the information can only be exported for 6 months back as our reports do not show information older than 6 months."


Has anyone been able to export a list of Shared Drives and their creators via GAM?

Any/all help is greatly appreciated.

-Tom

[Ross Scroggs]

Thomas,

Here's how to do it tith Advanced GAM (https://github.com/taers232c/GAMADV-XTD3).

https://github.com/taers232c/GAM-Scripts3/blob/master/GetTeamDriveOrganizers.py

Ross

--

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 on the web visit https://groups.google.com/d/msgid/google-apps-manager/32738efb-4a4c-405e-9419-3d01d6c12287n%40googlegroups.com.

[Thomas Prescott]

Thanks for the reply, Ross! However, this isn't exactly what I'm looking for.

The outputted TeamDriveOrganizers.csv lists all Shared Drives and their organizers (all good there). I'm looking for the user who created the Shared Drive, which in theory would only have one result per drive. This is different than anyone who currently is an drive organizer.

Ideally - a timestamp of when the Shared Drive was created, along with the user that created it is what I'm looking for. Could it be an API limitation? "Creator" doesn't seem to be a valid call on anything I've been able to find (but you're the expert here).

Thanks again.

[Ross Scroggs]

Thomas,

One Off

gam report drive filter "doc_id==Put Team Drive ID Here" event create

Multiple

Make a CSV file TeamDrives.csv with a column labelled id that contains Team Drive IDs.

gam redirect csv TeamDriveCreation.csv multiprocess csv TeamDrives.csv gam report drive filter "doc_id==~~id~~" event create

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/1830b849-2bec-4071-8c7a-2f382437afben%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Kim Nilsson]

And, as Google Support told you, that information is only available for 180 days, where after older data in the logs are cleared.

Unless you export the logs to BigQuery, or do regular exports to local log files.

So any Shared Drive created before September of 2020 has no such information available.

[Brian Kim]

I think Google may be changing that because of the recent changes to EDU, and how some were abusing it (e.g. Create a Shared Drive, add an external member, and remove themselves). For most of my Shared Drives in a test domain, creator information is visible for all Shared Drives except for two (creator is in "archived" status). I don't think this information is visible via the API.