Configuring report profiles and generating mail statistic reports

The Log & Report > Report Setting > Mail Statistics tab displays a list of report profiles.

A report profile is a group of settings that contains the report name, its subject matter, its schedule, and other aspects that the FortiMail unit considers when generating reports from log data. The FortiMail unit presents the information in tabular and graphical format.

You can create one report profile for each type of report that you will generate on demand or on a schedule.

Generating reports can be resource intensive. To avoid email processing performance impacts, you may want to generate reports during times with low traffic volume, such as at night. For more information on scheduling the generation of reports, see Configuring the report schedule.

To access this part of the web UI, your administrator account’s:

Domain must be System
access profile must have Read or Read-Write permission to the Others category

For details, see About administrator account permissions and domains.

To view and configure report profiles

Go to Log & Report > Report Setting > Mail Statistics.

GUI item	Description
Generate (button)	Select a report and click this button to generate a report immediately. See Generating a report manually.
Report Name	Displays the name of the report profiles.
Recipient Domain	Displays the name of the recipient domain.
Sender Domain	Displays the name of the sender domain.
Schedule	Displays the frequency with which the FortiMail unit generates a scheduled report. If the report is designed for manual generation, Not Scheduled appears in this column.

Click New to add a profile or double-click a profile to modify it.

A multisection dialog appears.

In Report name, enter a name for the report profile.

Report names cannot include spaces.

Expand your desired option and configure the following as needed:

Configuring the report time period.
Configuring the report query selection.
Configuring the report schedule.
Selecting the protected domains to report.
Configuring report conditions.
Configuring report email notification.

Click Create or OK.

Configuring the report time period

When configuring a report profile, you can select the time span of log messages from which to generate the report.

Select the time span option you want. This sets the range of log data to include in the report.

If you select “User Defined” or “Last N hours”, another field appears that requires more information.

Configuring the report query selection

When configuring a report profile, you can select one or more queries or query groups that define the subject matter of the report.

Each query group contains multiple individual queries, each of which correspond to a chart that will appear in the generated report. You can select all queries within the group by marking the check box of the query group, or you can expand the query group and individually select each query to include.

For example:

If you want the report to include charts about spam, select both the Spam by Sender and Spam by Recipient query groups.
If you want the report to specifically include only a chart about top virus senders by date, expand the query group Virus by Sender and select only the individual query Top Virus Sender By Date.

GUI item	Description
Mail Filtering Statistics	Select to include high-level categories, such as mail, spam, non-spam, and virus.
Mail High Level	Select to include all top level and summary information for all queries, such as Top Client IP By Date.
Mail Statistics	Select to include information on daily, hourly or weekly email message statistics, such as Mail Stat Messages By Day.
Mail by Recipient	Select to include information on email messages by each recipient, such as Top Recipient By Date.
Mail by Sender	Select to include information on email messages by each sender, such as Top Sender By Date.
Spam by Recipient	Select to include information on spam by each recipient, such as Top Spam Recipient By Date.
Spam by Sender	Select to include information on spam by each sender, such as Top Spam Sender By Date.
Statistics	Select to include information on generalized email message statistics (less granular than Mail Statistics).
Total Summary	Select to include summary information, such as Total Sent And Received.
Virus by Sender	Select to include information on infected email messages by each sender, such as Top Virus Sender By Date.
Virus by Recipient	Select to include information on infected email messages by each recipient, such as Top Virus Recipient By Date.

Configuring the report schedule

When configuring a report profile, you can select when the report will generate. Or, you can leave it unscheduled and generate it on demand. See Generating a report manually.

Generating reports can be resource-intensive. To improve performance, generate reports during times when traffic volume is low, such as at night or during weekends.

Selecting the Schedule dropdown menu reveals the following options:

GUI item	Description
Not Scheduled	Select if you do not want the FortiMail unit to generate the report automatically according to a schedule. If you select this option, the report can only be generated on demand. See Generating a report manually.
Daily	Select to generate the report each day. Also configure At hour.
These days	Select to generate the report on specific days of each week, then select those days. Also configure At hour.
These dates	Select to generate the report on specific date of each month, then enter those date numbers. Separate multiple date numbers with a comma. For example, to generate a report on the first and 30th day of every month, enter `1,30`. Also configure At hour.

Selecting the protected domains to report

When configuring a report profile, you must specify at least one protected domain as the recipient domain or sender domain whose log messages are used when generating the report. You can select more than one domain.

Disable All domains to reveal the available and selected domains sections.
In the Available domains area, select one or more domains that you want to include in the report and select the right arrows to move the domain to the Selected domains area.
To remove a domain from a report, select it in the Selected domains area and select the left arrows.

Configuring report conditions

When configuring a report profile, you can choose to report only on logged email messages matching the directionality that you select: incoming, outgoing, or both. You can also choose to report on logged email messages destined to certain IP addresses or IP group.

Configuring report email notification

When configuring a report profile, you can have the FortiMail unit email an attached copy of the generated report, in either HTML or PDF file format, to designated recipients.

In Report format, select the format of the generated attachment, either html or pdf.
In the Email address field, enter the email address of a recipient. Click >> to add the email address to the list of recipients.
The All notification Email address text box displays the list of recipients to whom the FortiMail unit will send a copy of reports generated using this report profile. To remove a recipient address, select it and click <<.

Generating a report manually

You can always generate a report on demand whether the report profile includes a schedule or not.

To manually generate a report

Go to Log & Report > Report Setting > Mail Statistics.
Click to select the report profile whose settings you want to use when generating the report.
Click Generate.

The FortiMail unit immediately begins to generate a report. To view the resulting report, see Viewing generated reports.

Configuring mailbox statistics

The FortiMail unit can generate reports on the total number of active mailboxes during a particular time period, as specified in the report profile creation. Mailbox statistic reports can be configured based on schedule, domain, and email address notification. After configuration, historical active mailbox counts over the last 30 days and 12 months can be viewed under FortiView > Mail Statistics > Active Mailbox.

The configuration of mailbox statistic reports is license based. If you do not purchase the MSSP license, this feature is not available.