Shared Drive space used

[Ian Crew]

Hi all:

Can someone could confirm my memory that there's not currently any good/efficient way to see how much space a given Shared Drive is using. Is that correct?

Hoping I’m wrong, and thanks,

Ian

[Ian Crew]

To elaborate, I’m actually hoping to generate a report of all of the Shared Drives in our Workspace instance along with how much space each one is using (and, ideally, who the members are). 

Thanks all!

Ian

--

Ian Crew Solutions Architect Productivity & Collaboration Services Information Services and Technology

[Brian Kim]

Hi Ian,

The best way is to use drive file stream and right click on your PC/Mac. It will show you the size.

I would imagine rclone size or about may work as well.

https://www.youtube.com/watch?v=7B0ei3Pi_Jk

[Ian Crew]

Thanks Brian:

I’m wondering not just about the Shared Drives I’m a part of, but all of them, across our entire Google Workspace instance (with ~170,000 active accounts at the moment). 

Ian

--
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/dee8c1b0-ba06-4c8e-8c01-5ca47ecfdbden%40googlegroups.com.

[Mitchell Hoffman]

Ian,

For percentages you can use the gui

https://admin.google.com/ac/drive/manageshareddrives?hl=en

With rclone, you can do 

rclone size shareddrivename:

and to get file/folder counts

rclone tree "shareddrivename:" | grep directories | awk '{print $1 + $3}'

[Brian Kim]

you can use --drive-impersonate with rclone as well if you have a list of managers for each.

[Mike Beane]

I remembered seeing this from Steve Larsen last year (i.e. untested, YMMV, etc) and that's the closest thing I've seen outside of the rclone suggestions.

-----------------------------

If you need to get storage used which is irrelevant really for a Shared Drive, you can use

gam user steve print filelist select 0AEbLHNmHuE_12345 fields filesize | awk -F"," '{print;x+=$2}END{printf "Total Bytes %.1f\n", x}'

On Friday, 24 July 2020 at 13:53:36 UTC-5 Steve Larsen wrote:

Run a command like the following. You will get the total number of objects that this is then divided by the max allowed currently which is 400,000.

gam user steve print filelist select 0AEbLHNmHuE_12345 countsonly | awk -F',' 'FNR == 2 {print $2, $2/400000}'

On Friday, 24 July 2020 at 09:41:22 UTC-5 Mitchell Hoffman wrote:

Morning Gam community,

I have looked but not found a way to retrieve the value for "space used" for a shared drive.

Which can be revealed here in the admin portal:

https://admin.google.com/ac/drive/manageshareddrives

Is this currently an API call that is available?

thanks in advance

--

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/4BC1632A-D55C-46E6-87E5-3633969F0307%40berkeley.edu.

[Ian Crew]

Thanks, all.

So what I’m hearing is that there isn’t any reporting or API available from Google, so that getting an overview of the space used by each Shared Drive would be a matter of iterating through all of our users, checking which Shared Drives they have access to, then iterating through each of those shared drives to add up the amount of space used by all of the files in that particular Shared Drive.

At the scale we operate at here at UC Berkeley (with over 170,000 active accounts at the moment), that’s not really practical in any reasonable timeframe, so I think I’m safe in telling my boss “no, sorry, it’s not something we can really do right now”.

Cheers,

Ian

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAHcQ0DTBQQnPU5d964fChoXvYtDKkOstoLQm-jP1F%2BCmynW3ug%40mail.gmail.com.

[Brian Kim]

Exactly. Not a good use of your time. :) 

[Ross Scroggs]

Ian,

Look at this: https://github.com/taers232c/GAM-Scripts3/blob/master/GetTeamDriveCountsSize.py

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/2FE0A4DC-D27E-4B07-8F4E-864DD1084980%40berkeley.edu.

--

Ross Scroggs

ross.s...@gmail.com