Custom Reports, Using This Feature, Scheduling | Fortinet FortiDB

Custom Reports

Report Manager

Custom Reports

Custom Reports

Using the open-source JasperReports library1, the Quartz scheduling librar2y, the chart generating Kavachart libra3ry, and the open-source iReport design too4l, you can produce your own custom reports to complement those offered by the FortiDB MA Report Manager.

As an example, FortiDB MA is shipping with an Alert Statistics Report and Template, produced by the above tools and libraries.

Reports can be generated in PDF, HTML, or Excel format.

Using This Feature

In general, the steps to use the Custom Reports feature are.

1Set a schedule for all reports or for an individual report

2Go to the Company Information page and provide the appropriate information

3Generate the report

aChoose the report and template combination you want

bFilter the report by time or data categories

cChoose an output format type

4(Optionally) view the Report History page to manage which reports you want to keep or discard.

Scheduling

You can set a schedule for running all of your Custom Reports at once or set an individual report's schedule.

To set a schedule, click the Schedule Settings link from the left-side navigation menu or go to Set Defaults -> Schedule Settings from the top menu.

1.See http://jasperreports.sourceforge.net/

2.See http://www.opensymphony.com/quartz/

3.See http://www.ve.com

4.See http://ireport.sourceforge.net/

	FortiDB Version 3.2 Utilities User Guide
30	15-32000-81369-20081219

Image 32

Fortinet FortiDB manual Custom Reports, Using This Feature, Scheduling

Contents

Utilities User Guide FortiDB Utilities User Guide Trademarks Table of Contents Index FortiDB MA Utilities Auto Discovery Selecting Addresses for Auto-Discovery Selecting Non-Standard Ports for Auto-Discovery Results from Auto-Discovery MS-SQL Discovered Database Information Populating Connection Form MS-SQL Connection Summary Connection Summary Button Connection Summary Output Rule Chaining Setting Screen Rule Chaining Rule Chaining Chaining with Parameterized User-Defined Rules Parameterized User-Defined Rule Flow Diagram General Pudr Steps Disabled Parameter Checkboxes Validating the Pudr before Saving Item Setting for Session Policy Example of Chaining to a PL/SQL-based Pudr Policy Settings for Suspicious Login Time Immediate Resulting Killed Session Table Columns That Could Appear in AlertsChained-Rule Alerts UBM Session Policy and Pudr Multiple Source-Rule-Violation Behavior DB Example Rule Chaining Alert Report Manager Setting a Report ScheduleSetting a Timer-based Schedule Deleting a Previously Set Timer Schedule Setting a Calendar-based ScheduleSetting a Timer-Based Schedule Deleting a Timer Schedule Setting a Combined Schedule Setting a Randomized IntervalSetting a Calendar-Based Schedule Setting a Randomized Interval Reporting by Time Enabling Email RecipientsSpecifying Report Parameters ARM Reporting by Time ARM Reporting by Time Calendar Pop-up New Report Setting Screen top New Reports Menu New Report Setting Screen bottom Saved and Enabled Report Using the Select Checkbox to Affect Multiple Reports Activating ARM Running and Analyzing ReportsStatus Menu Status Dialog View Reports Dropdown List on Current Reports Screen Current Report Configuration Report Summary ActionChoosing Summary Report Action Summary-Action Output Types Report Size Archiving Reports Report Detailed ActionLimitation Using This Feature Custom ReportsScheduling Custom Reports Time-only Schedule Settings Daily Schedule Settings Customer and Company Information Weekly Schedule SettingsMonthly Schedule Settings Custom Reports Main Report and Template Generation and ManagementCompany Information Dialog Adding a Report Adding ReportsModifying Reports Deleting a Report Deleting ReportsModifying a Report Modifying Report Templates Templates Manager Modifying a Template Generating ReportsReport Result Generated Html Report Example Report History Report History Licensing and Administration User Administration for Custom Reports and SOX ReportsReports radio button on the User Administration screen Property Purpose Possible Values Default Property Purpose Possible Values Default1 Limitations SOX Compliance Reports SOX Reports within Custom Reports Manager General Setup Instructions Reports and AcronymsCommon Report Header Fields Report Name Acronym Cobit Objectives and Setup Requirements History of Privilege Changes Report HPCReport Body Columns HPC Report Sample Abnormal or Unauthorized Changes to Data Report AUC AUC Report Sample Abnormal Use of Service Accounts Report AUS AUS Report Sample Abnormal Termination of Database Activity Report ATD ATD Report Sample EPA Report Sample End of Period Adjustments Report EPASettings Dialog for the EPA Report Case Assumptions Verification of Audit Settings Report VAS VAS Report Sample Report Size Licensing and AdministrationArchiving Reports Verification of Audit Settings Report VAS Index