Scheduled Reports


You can schedule reports to run on a regular basis, and have the results emailed to the user in PDF format. These reports include summary values at the top (for example, the number of requests, SLA breaches, alerts triggered, and unique clients in a specified week) followed by a table of services, and their aggregated usage data (for example, the number of requests on each service).

The report data is for the configured current week of the report, which is compared to the week before. You can set the configured current week of the report to be the actual current calendar week or any prior week (provided there is corresponding data in the database).

To configure scheduled reports, right-click the Listeners -> API Gateway Analytics node in the Policy Studio tree, and select Database Archive.

Database Configuration

Click the browse button the right, and select a pre-configured database connection in the dialog. This setting defaults to the Default Database Connection. To add a new database connection, right-click the Database Connections node, and select Add DB connection. You can also edit or delete existing nodes by right-clicking and selecting the appropriate option. Alternatively, you can add database connections under the External Connections node in the Policy Studio tree view. For more details on creating database connections, see the Database Connection topic.

Scheduled Reports Configuration

You can configure the following settings for scheduled reports:

Enable Report Generation:

Select whether to enable scheduled reports in PDF format. When selected, by default, this runs a scheduled weekly report on Monday morning at 0:01. For details on configuring a different time schedule, see the next setting. This setting is not selected by default.

When Enable Report Generation is enabled, you can configure the following settings on the Report Generator Process tab:

Connect to API Gateway Analytics as User:

Enter the username and password used to connect to the report generator process. Defaults to the values entered using the configureserver script (for example, admin/changeme).


Enter the directory used for the generated report files in the Output Directory field, or click Choose to browse to the directory. Defaults to the directory entered using the configureserver script (for example, c:\temp\reports). You can also select to Do not delete report files after emailing. This setting is not selected by default.

SMTP Configuration

When Enable Report Generation is enabled, you can configure the following settings on the SMTP tab. These settings default to those entered using the configureoaganalytics script.

Email Recipient (To):

Enter the recipient of the automatically generated email (for example, Use a semicolon-separated list of email addresses to send reports to multiple recipients.

Email Sender (From):

The generated report emails appear from the sender email address specified here (for example,

[Note] Note

Some mail servers do not allow relaying mail when the sender in the From field is not recognized by the server.

SMTP Server Settings:

Specify the following fields:

Outgoing Mail Server (SMTP) Specify the SMTP server used to relay the report email (for example,
Port Specify the SMTP server port to connect to. Defaults to port 25.
Connection Security Select the connection security used to send the report email (SSL, TLS, or NONE). Defaults to NONE.

Log on Using:

If you are required to authenticate to the SMTP server, specify the following fields:

User Name: Enter the user name for authentication.
Password: Enter the password for the user name specified.