Google Drive space report command?

205 views
Skip to first unread message

Jason Komendat

unread,
Apr 6, 2021, 11:36:55 AM4/6/21
to GAM for Google Workspace
It mentions I cna use this command gam config csv_output_row_filter "accounts.*used_quota_in_mb:count>=15000" redirect csv ./BigUsers.csv report users select ou_ns </Path/To/OU> fields accounts:drive_used_quota_in_mb,accounts:used_quota_in_mb to get a drive size CSV report. When I run it I get a CSV wiht the titles for the fields but blank data

Am I missing something obvious?

Ross Scroggs

unread,
Apr 6, 2021, 11:41:05 AM4/6/21
to google-ap...@googlegroups.com
Jason,

Probably because no user had more than 15000 mb of used quota; try a smaller value.

Ross

--
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/5d70d25e-920f-42c2-a5f9-fe72adfb428bn%40googlegroups.com.


--

Ross Scroggs

unread,
Apr 6, 2021, 11:44:13 AM4/6/21
to google-ap...@googlegroups.com
Jason,

If you want the used_quota_in_mb regardless of size, drop the following clause:
config csv_output_row_filter "accounts.*used_quota_in_mb:count>=15000" 

Ross
--

Jason Komendat

unread,
Apr 6, 2021, 11:45:04 AM4/6/21
to GAM for Google Workspace
I thought about that so I already set it to 5G because I know at least my account for one has over that and still just get a blank file with these headers

email,date,accounts:drive_used_quota_in_mb,accounts:used_quota_in_mb



Jason Komendat

unread,
Apr 6, 2021, 12:05:44 PM4/6/21
to GAM for Google Workspace
OK, I found it I was doing the staff root OU it doesn't do the sub OU's so I have to specify them

James SEYMOUR

unread,
Jun 6, 2021, 10:44:20 PM6/6/21
to GAM for Google Workspace
Hi Jason,

You can specify ou_and_children and use the top level OU to include sub-OUs. You can add _ns on the end (ou_and_children_ns) if you want to limit to Non-Suspended (active) accounts.

Cheers

James

Jason Komendat

unread,
Jun 10, 2021, 11:05:20 AM6/10/21
to GAM for Google Workspace
I didn't know about that, thanks
Reply all
Reply to author
Forward
0 new messages