Reports

gPanel / gPanel Beyond / Reports

The reporting section will allow you to create and export reports based on a service and a property. You can choose from Adhoc reports and Canned reports. The Adhoc reports feature will allow you to create a custom report that can be displayed and exported. The Canned reports feature will allow you to display and export a predefined report.

Create an Adhoc Report

Adhoc reports will allow you to create a custom report. Steps include selecting the Service and selecting the Property.

To create an Adhoc report select Adhoc Report as the Report Type.

Next, select the service you want to run the report on.

Now, select the property of the service you want to run the report on.

The following are the Service Properties that you can select from:

Users

  • Total Accounts

  • Active Accounts

  • Suspended Accounts

Groups

  • Total Groups

  • Team Groups

  • Team Plus Net Groups

  • Announce Groups

  • Restrict Groups

  • Allow External Members

  • Not Allow External Members

  • Allow Web Posting

  • Not Allow Web Posting

  • Archived Groups

  • Not Archived Groups

  • Show in Group Directory

  • Not Shown in Group Directory

Docs

  • Total Docs

  • Documents

  • Spreadsheets

  • Presentations

  • Folders

  • Drawings

  • Forms

  • PDF

  • Images

  • Video

  • Non Native Docs

  • Native Docs

  • Quota

Doc Shares

  • Shares

  • User Viewers

  • User Editors

  • Group Viewers

  • Group Editors

  • Internal Shares

  • Internal User Viewers

  • Internal User Editors

  • Internal Group Viewers

  • Internal Group Editors

  • External Shares

  • External User Viewers

  • External User Editors

  • External Group Viewers

  • External Group Editors

  • Shared to Domain

  • Shared to Domain View

  • Shared to Domain Edit

  • Shared to Domain with Link View

  • Shared to Domain with Link Edit

  • Shared to Public

  • Shared to Public view

  • Shared to Public Edit

  • Shared to Public with Link View

  • Shared to Public with Link Edit

Sites

  • Total Sites

Site Shares

  • Shares

  • User Owners

  • User Viewers

  • User Editors

  • Group Viewers

  • Group Editors

  • Group Owners

  • Internal Shares

  • Internal User Owners

  • Internal User Viewers

  • Internal User Editors

  • Internal Group Owners

  • Internal Group Viewers

  • Internal Group Editors

  • External Shares

  • External User Owners

  • External User Viewers

  • External User Editors

  • External Group Owners

  • External Group Viewers

  • External Group Editors

  • Shared to Domain

  • Shared to Domain View

  • Shared to Domain Edit

  • Shared to Domain with Link View

  • Shared to Domain with Link Edit

  • Shared to Public

  • Shared to Public view

  • Shared to Public Edit

  • Shared to Public with Link View

  • Shared to Public with Link Edit

Once the Report Type, Service, and the Property have been selected, click on Search to begin the report. It could take some time to run, but once it is completed it will be displayed to you.

To export the report results, click on the Export Results button.

This will create a new Google Spreadsheet with the results. The spreadsheet will be created under the account of the user who is logged in and clicked on the Export Results button.

Click on the Reset button to reset the Report Type, Service, and Property for a new report.

Create a Canned Report

The Canned Reports are pre-defined reports.

Currently the only Canned Report available is Doc Users. This report will display a list of users using Drive, as well as the number of documents they own.

To create an Adhoc report select Canned Report as the Report Type.

Next, select the service you want to run the report on.

Once the Report Type, and the Service have been selected, click on Search to begin the report. It could take some time to run, but once it is completed it will be displayed to you.

Click on the Reset button to reset the Report Type, and Service for a new report.

Scenario

It's Wednesday afternoon and just as you are about to leave for lunch you receive a email from your boss. In the email your boss states that they need a list of all of the current groups in your company's Google Workspace domain that are allowed to have external members. Your company has thousands of groups and this would be tedious task that could take all day, except you had the foresight to get gPanel Data Security. You fire it up and click on the Reporting feature. You create an Adhoc Report for "Groups" that "Allow External Members". You export the results (or your search) and share out the list to your boss.