Daily Reporting external emails to and from a Group

Finding all emails sent/received by a user

If you have a requirement to report on a daily basis all external emails sent to a list of users or sent from a list of users then follow these steps.

Go to GAT+ and open Email Audit ,select User Statistics and under the Daily statistics select the User and Date. The result will show you statistics for the selected date and user.

An admin can check in and export this data into spreadsheet in a glance. This allows global overview of all emails sent and received from this user, and if they used alias account it will show how many emails they sent or received with the alias.

Note: The search example above was for an individual users and not a Google group or alias.

Finding all emails sent/received by a Google group or by members of an Org Unit

We can also find emails Sent to and From an email, but from perspective of a Email Group or alias account.

To do so follow these steps:

Open GAT+ and scroll to  Email Audit ,select User Statistics then Daily statistics.

Select ‘Apply custom filter’ on the right hand side, a new window will pop up.

Select the Type to Stats by Date Range and Users, select Date From and Date To and the Group email you are interested in.

In the above example I selected the two dates:

Date From June 5, 2019

Date To June 5, 2019

And for the scope I selected members of Support Google Group.

The results will list out all of the members of the Support Google Group and all of the aliases they used to send or receive emails on the 5th of June.

To create this report as a scheduled daily report, follow these steps:
Select “Scheduled” and pick the occurrence as “Every day – after midnight”.
Choose the list of recipients. and activate by pressing the ‘Apply & Schedule’ button.

Note: When you select “Apply & Schedule” the result will be displayed right-away. Each of the stats numbers can be selected and it will lead you to the exact emails

A report will be generated on a daily basis and the recipients will receive email notification every midnight with the spreadsheet of the result.

In the spreadsheet the ‘User’ column is the account that was used. The ‘Email’ column is the email alias from which the email was sent from.

Comments

comments