Fortinet black logo

Administration Guide

Configuring report profiles and generating mail statistic reports

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.

Note

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
  1. Go to Log & Report > Report Setting > Mail Statistics.
  2. 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.

  3. Click New to add a profile or double-click a profile to modify it.
  4. A multisection dialog appears.

  5. In Report name, enter a name for the report profile.
  6. Report names cannot include spaces.

  7. Expand your desired option and configure the following as needed:
  • 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.

    Note

    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.

    1. Disable All domains to reveal the available and selected domains sections.
    2. 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.
    3. 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.

    1. In Report format, select the format of the generated attachment, either html or pdf.
    2. In the Email address field, enter the email address of a recipient. Click >> to add the email address to the list of recipients.
    3. 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
    1. Go to Log & Report > Report Setting > Mail Statistics.
    2. Click to select the report profile whose settings you want to use when generating the report.
    3. 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.

    Note

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

    To view and configure report profiles
    1. Go to Log & Report > Report Setting > Mailbox Statistics.
    2. 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.

      Domain

      Displays the domain name(s).

      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.

    3. Click New to add a profile or double-click a profile to modify it.
    4. A multisection dialog appears.

    5. In Report name, enter a name for the report profile.
    6. Report names cannot include spaces.

    7. Enable Include mailbox list to include information about the active mailboxes per domain and their last delivery time.
    8. Expand your desired option and configure the following as needed:
  • 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 from either Today, Yesterday, This month, or Last month. This sets the range of log data to include in the report.

    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.

    Note

    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.

    Weekly

    Select to generate the report on specific days of each week, then select those days. Also configure At hour.

    Monthly

    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 whose log messages are used when generating the report. You can select more than one domain.

    1. Disable All domains to reveal the available and selected domains sections.
    2. 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.
    3. To remove a domain from a report, select it in the Selected domains area and select the left arrows.

    Configuring report email notification

    When configuring a report profile, you can have the FortiMail unit email an attached copy of the generated report to designated recipients.

    1. In the Email address field, enter the email address of a recipient. Click >> to add the email address to the list of recipients.
    2. 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
    1. Go to Log & Report > Report Setting > Mailbox Statistics.
    2. Click to select the report profile whose settings you want to use when generating the report.
    3. Click Generate.

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

    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.

    Note

    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
    1. Go to Log & Report > Report Setting > Mail Statistics.
    2. 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.

    3. Click New to add a profile or double-click a profile to modify it.
    4. A multisection dialog appears.

    5. In Report name, enter a name for the report profile.
    6. Report names cannot include spaces.

    7. Expand your desired option and configure the following as needed:
  • 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.

    Note

    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.

    1. Disable All domains to reveal the available and selected domains sections.
    2. 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.
    3. 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.

    1. In Report format, select the format of the generated attachment, either html or pdf.
    2. In the Email address field, enter the email address of a recipient. Click >> to add the email address to the list of recipients.
    3. 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
    1. Go to Log & Report > Report Setting > Mail Statistics.
    2. Click to select the report profile whose settings you want to use when generating the report.
    3. 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.

    Note

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

    To view and configure report profiles
    1. Go to Log & Report > Report Setting > Mailbox Statistics.
    2. 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.

      Domain

      Displays the domain name(s).

      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.

    3. Click New to add a profile or double-click a profile to modify it.
    4. A multisection dialog appears.

    5. In Report name, enter a name for the report profile.
    6. Report names cannot include spaces.

    7. Enable Include mailbox list to include information about the active mailboxes per domain and their last delivery time.
    8. Expand your desired option and configure the following as needed:
  • 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 from either Today, Yesterday, This month, or Last month. This sets the range of log data to include in the report.

    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.

    Note

    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.

    Weekly

    Select to generate the report on specific days of each week, then select those days. Also configure At hour.

    Monthly

    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 whose log messages are used when generating the report. You can select more than one domain.

    1. Disable All domains to reveal the available and selected domains sections.
    2. 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.
    3. To remove a domain from a report, select it in the Selected domains area and select the left arrows.

    Configuring report email notification

    When configuring a report profile, you can have the FortiMail unit email an attached copy of the generated report to designated recipients.

    1. In the Email address field, enter the email address of a recipient. Click >> to add the email address to the list of recipients.
    2. 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
    1. Go to Log & Report > Report Setting > Mailbox Statistics.
    2. Click to select the report profile whose settings you want to use when generating the report.
    3. Click Generate.

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