Reports

Contents

1 Create Report
2 Run Report
3 Edit Report
4 Sorting Reports
5 Delete Report
6 Available Report Options

Create Report

1. Click the Add Report button in the top right hand corner.

2. Enter the report information and click Next. Report information includes the following details.

Report Name
Report Type ( See Available Report Options for details on report types )
Enable/Disable Manual Run
Enable/Disable Scheduled Run
Description

3. Select the Available Columns to be included in the report and click Next.

5. Review the information and run the report. This will generate a Google Spreadsheet in the Drive account of the user who ran in.

Run Report

1. Scheduled Reports will run on a set schedule automatically. For Manual reports, click on Run Now next to the report to run.

2. The report will generate a Google Spreadsheet with the results.

Edit Report

1. Select Edit for the existing report to edit.

2. All fields can be edited. See Available Report Options for report field details.

Sorting Reports

You can sort your Reports that you have previously created by Report Name, Created ON, Description, Report Type.

To select a header to sort simply click onto it, the header will highlight red with a directional arrow depending on whether you prefer A-Z, Z-A.

For "Created ON" & "Last Ran On" it will be the most recently created to oldest or oldest to most recently created.

Delete Report

1. Select the Report to delete and click the Delete Report button in the top right hand corner.

2. Confirm the deletion by clicking Delete

Available Report Options

Report Type

Available Columns

Source Selection

Doc Activity

Email
Profile ID
Etag
Application Name
Customer ID
Time
Unique Qualifier
IP Address
Event Name
Type
Value
Name

Login Activity

Email
Profile ID
Etag
ApplicationName
Customer ID
Time
Unique Qualifier
IP Address
Event Name
Type
Value
Name

Customer Usage

Date
Client ID
Client Name
Number of Users

User Usage

User
Date
Value
Name

User Quota

User Email
Date
Total Quota Available in MB
Used Quota in MB
Used Quota Percentage
Drive Used Quota in MB
Gmail Used Quota in MB
Google Plus Photos Used Quota in MB

Email Delegate

User Email
Delegate

Users Email
Groups
Organization
gPanel Role

Email Forwarding

User Email
Enabled
Forward to Email
Action

Users Email
Groups
Organization
gPanel Role

Email Monitor

User Email
Request ID
Listening User
Monitored User
Start Date
Full Outgoing
Full Incoming
Draft Monitoring
Chat Monitoring

Users Email
Groups
Organization
gPanel Role

Hidden Users

User Email
Is Hidden From Directory

Users Email
Groups
Organization
gPanel Role

Inactive Users

User Email
Is Inactive

Users Email
Groups
Organization
gPanel Role

Last Login

User Email
Last Login

Users Email
Groups
Organization
gPanel Role

Super Admins

User Email
Is Super Admin

Users Email
Groups
Organization
gPanel Role

Suspended Users

User email
Is Suspended
Suspended Reason

User Email
Groups
Organization
gPanel Role

User Profile

User Email
First Name
Last Name
Full Name
Assistant Phone
Callback Phone
Car Phone
Company Main Phone
Grand Central Phone
Home Phone
Home Fax
ISDN
Main Phone
Mobile Phone
Other Phone
Other Fax
Pager
Work Pager
Radio
Telex
tty tdd
Work Phone
Work Fax
Work Mobile Phone
Work Organization Name
Work Organization Title
Work Organization Department
Home Address
Work Address
Other Address
Work Email
Home Email
Other Email

AIM
gTalk
ICQ
Jabber
MSN
Net Meeting
QQ
Skype
Yahoo
Aliases
Creation Time
Customer ID
Last Login Time
Org Unit Path
Suspension Reason
Thumbnail Photo URL
Organization External ID
Network External ID
Customer External ID
Account External ID
Non-Editable Alias
Assistant
Brother
Child
Domestic Partner
Father
Friend
Manager
Mother
Parent
Partner
Referred By
Relative
Sister
Spouse

User Email
Groups
Organization
gPanel Role

Two Factor Enrolled

User Email
Date
Two Factor Enrolled

User Email
Groups
Organization
gPanel Role

Org With No Members

Org Unit Path
Org Name
Description
Parent Org Path
Block Inheritance

Org Member Count

Org Unit Path
Org Name
Description
Parent Org Path
Block Inheritance
Number of Users

Organization

Group

Group Email
ID
Name
Description
Admin Created
Aliases
Non-Editable Aliases
Number of Users
Custom Reply To
Default Message Deny Notification Text
Max Message Byte
Allow Web Posting
Show in Group Directory
Allow External Members
Send Message Deny Notification
Is Archived
Archive Only
Primary Language
Who Can View Membership
Who Can Post Messages
Who Can Join
Who Can View
Who Can Invite
Spam Moderation Level
Message Moderation Level
Reply To
Include in Global Address List
Allow Google Communication
Members Can Post as the Group
Message Display Font

Groups

Group Member Count

Group Email
ID
Name
Description
Admin Created
Aliases
Non-Editable Aliases
Number of Users

Groups

Group Membership

Group Email
Group ID
Name
Member Email
Member Type
Member Role
Member ID

Groups

Groups With No Owners

Group Email
ID
Name
Description
Admin Created
Aliases
Non-Editable Aliases
Number of Users

Groups

Groups With Nested Groups

Group Email
ID
Name
Description
Admin Created
Aliases
Non-Editable Aliases
Number of Users
Nested Group Email

Empty Groups

Group Email
ID
Name
Description
Admin Created
Aliases
Non-Editable Aliases

Docs Shared Externally

Doc Owner
Doc Title
Is Copyable
Created Date
Description
Editable
Explicitly Trashed
File Extension
File Size
ID
Last Modifying User
Last Modifying User Name
Mime Type
Modified Date
Quota Bytes Used
Self Link
Can Writers Share
Hidden
Trashed
Viewed
Restricted
Shares Email Address
Shares Domain
Shares Name
Shares Role
Shares Type

Users
Groups
Organizations
gPanel Roles

Docs Shared Publicly

Doc Owner
Doc Title
Is Copyable
Created Date
Description
Editable
Explicitly Trashed
File Extension
File Size
ID
Last Modifying User
Last Modifying User Name
Mime Type
Modified Date
Quota Bytes Used
Self Link
Can Writers Share
Hidden
Trashed
Viewed
Restricted
Shares Email Address
Shares Domain
Shares Name
Shares Role
Shares Type

Users
Groups
Organizations
gPanel Roles

Docs Over 100MB

Doc Owner
Doc Title
Is Copyable
Created Date
Description
Editable
Explicitly Trashed
File Extension
File Size
ID
Last Modifying User
Last Modifying User Name
Mime Type
Modified Date
Quota Bytes Used
Self Link
Can Writers Share
Hidden
Trashed
Viewed
Restricted

Users
Groups
Organizations
gPanel Roles

Docs Over 10MB

Doc Owner
Doc Title
Is Copyable
Created Date
Description
Editable
Explicitly Trashed
File Extension
File Size
ID
Last Modifying User
Last Modifying User Name
Mime Type
Modified Date
Quota Bytes Used
Self Link
Can Writers Share
Hidden
Trashed
Viewed
Restricted

Users
Groups
Organizations
gPanel Roles

Docs Shared With Groups

Doc Owner
Doc Title
Is Copyable
Created Date
Description
Editable
Explicitly Trashed
File Extension
File Size
ID
Last Modifying User
Last Modifying User Name
Mime Type
Modified Date
Quota Bytes Used
Self Link
Can Writers Share
Hidden
Trashed
Viewed
Restricted
Shares Email Address
Shares Domain
Shares Name
Shares Role
Shares Type

Users
Groups
Organizations
gPanel Roles

Docs Modified in Last 14 Days

Doc Owner
Doc Title
Is Copyable
Created Date
Description
Editable
Explicitly Trashed
File Extension
File Size
ID
Last Modifying User
Last Modifying User Name
Mime Type
Modified Date
Quota Bytes Used
Self Link
Can Writers Share
Hidden
Trashed
Viewed
Restricted

Users
Groups
Organizations
gPanel Roles

Docs With MP3 Extension

Doc Owner
Doc Title
Is Copyable
Created Date
Description
Editable
Explicitly Trashed
File Extension
File Size
ID
Last Modifying User
Last Modifying User Name
Mime Type
Modified Date
Quota Bytes Used
Self Link
Can Writers Share
Hidden
Trashed
Viewed
Restricted

Users
Groups
Organizations
gPanel Roles