Domain level reports

Gopher for Drive’s Domain level reports tab gives you access to the following reports:

  • Domain usage: Generates a report of the amount of used storage for a select number of days for Drive, shared drives, photos, Gmail, and total usage.
  • Storage by user: Generates a report with a select amount of users (Max 100,000) as of a certain date who have more than x amount of storage.

    Note: The users presented are pulled alphabetically. So, running a report may not always generate the usage from the highest users.

Accessing domain level reports

To access Gopher for Drive domain level reports:

  1. Open a new Google Sheet.
  2. In the top menu, go toAdd-ons > Gopher for Drive > Launch Sidebar.
  3. Click the Domain usage report tab.

Running the domain usage report

  1. From the Gopher for Drive sidebar, be sure the Domain level reportstab is selected.
  2. Click Domain Usage Report.
  3. Enter the number of days to include in the report. For example, if you enter 7, the report will include usage information for the past 7 days.
  4. Select an option to replace or merge information in the report. If Replace existing report is selected, the report will replace the values in the Domain Usage Report sheet with new data. If Merge with existing report is selected, new information is appended to the end of the existing information.

    Note: Merged information is appended to the end of the existing report. The users presented are pulled alphabetically. So, running a report may not always generate the usage from the highest users. The users presented are pulled alphabetically. So, running a report may not always generate the usage from the highest users.

  5. Click Load to Sheet.

DomainUsageOutputHL.png

Column Description
Date

The amount of storage used as of that date

Drive usage in MB Total drive usage in megabytes for the entire tenant as of the date in Column A
Shared drive usage in MB The total size of all shared drives as of the date from Column A
Photos usage MB Total storage from photos.google.com as of the date from Column A
Gmail usage in MB Total storage coming from Gmail as of the date from Column A

Total usage in MB

Combination of the storage in Columns B - E in megabytes as of the date in Column A
Total usage: % Change The change of total usage from the previous date, represented as a percentage. If usage has decreased from the previous date, it will be shown as a negative percentage.

 

Running the Storage by user report

  1. From the Gopher for Drive sidebar, be sure the Domain level reports tab is selected.
  2. Click Storage by User Report.
  3. Enter the number of users to include in the report. For example, if you enter 50, the report will include usage information of 50 users.

    Note: The users are pulled alphabetically. So, running the report may not always generate usage from the highest users.

  4. Enter a date to run the report by entering a date or selecting a date from the calendar in the Choose a date field.
  5. Use the Find users filter to type the desired a storage level to report on. Only users with more than the selected amount of storage appear on the report. 
  6. Check the Include Directory metadata checkbox to include the following additional information for users: Org Unit Path, Suspended State, Date the user was created, Last Login, and First and Last Name.
  7. Click Load to Sheet.
    StoragebyUserOutputHL.png

Report output:

The output is sorted by total usage with the highest usage being at the top. 

If you run a report and get “No data matches your query,” you may consider changing the date to at least 2 days before the current date.