Determine total number of files contained within corporate Google Drive

How can I as a Google super administrator determine the total number of files that all of our company's users have within Google Drive?

So far I have only been able to determine things such as the total size of all of our data or how many files have been added each day but haven't been able to determine the total number of files contained within our corporate Google Drive.

I understand that their are custom URL hyperlinks available to display data such as this that can't be directly accessed by going through the website. For example the custom URL https://admin.google.com/AdminHome?hl=en&fral=1#Reports:subtab=apps-usage-activity was provided to me by someone else which does display more detailed information that had been unavailable to me.
IT GuyNetwork EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RartemassLife CoachCommented:
That link is for the G Suite Administrator. Accounts for that cost about $5 a month and give you much more data for business and admin purposes. It does have a 14 day free trial however so you could create an account, get the info you need then complete the trial without committing to pay.
https://gsuite.google.com/intl/en/?utm_campaign=apps-help-center-promotion&utm_medium=et&utm_source=apps-help-center&utm_content=en

I don't believe there are any tools or searches available for a standard user that would give that information.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Allen FalconCEO & Pragmatic EvangelistCommented:
@rartemass,
The poster is the Superadmin for the G Suite account.

The total number of files is not available through the Admin console.  You would need to explore the Admin APIs.  Looking at Dito's GAM tool, I don't believe number of docs is a number you can pull. I think you would need to generate an export of filenames and count.
0
IT GuyNetwork EngineerAuthor Commented:
Can you give me more info on Dito's GAM tool?
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Allen FalconCEO & Pragmatic EvangelistCommented:
Here is the link: https://github.com/jay0lee/GAM/wiki

I don't see documentation for pulling number of files per domain, or per user.
0
IT GuyNetwork EngineerAuthor Commented:
Does anyone know how to do this?
0
Allen FalconCEO & Pragmatic EvangelistCommented:
Using BetterCloud, I was able to export a list of all files by create date, which gave me a tally.  

Not sure how feasible this is for you.
0
IT GuyNetwork EngineerAuthor Commented:
Allen Falcon,

Can you please provide me with step by step instructions on how you did this?

Does Better Cloud need to be purchased or is there an evaluation or trial version available that can do this?
0
Allen FalconCEO & Pragmatic EvangelistCommented:
BetterCloud is an add-on product for G Suite that provides admin tools and added security.

I would suggest trying to pull a full file list using GAM (sorry, I don't use it enough to provide steps) before looking at spending $$ on bettercloud.

If you try GAM and still want to try BetterCloud, contact us and we will work to get you a trial.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Google

From novice to tech pro — start learning today.