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:

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.