Reports Database Tool

FortiWAN’s Reports stores database in the built-in hard disk (HDD) for long-term analysis and reports. As the data increases, storage consumption increases. The Reports database tool (DB tool) is an application running on your local computer to manage remote FortiWAN Reports database. Note that the DB tool must be ran on a host that can access FortiWAN Web UI. Please contact Fortinet CSS to get the tool and install it following the instructions below.

A Web-based Reports database management tool providing limited functions similar to the Reports database tool is available, see Database Data Utility.

Installation Procedures

Step 1: Click the installation file (such as FWN-dbtool-4.0.0-B20150303.exe) to run the installer. Select the language of your choice.

Step 2: Read the System Requirements.

Step 3: Click ‘Next’ to begin the setup.

Step 4: Read the License Agreement carefully. Click the ‘I Agree’ button to accept the agreement and begin the installation process. Otherwise, please click ‘Cancel’.

Step 5: Choose a destination folder for setup and click ‘Next’.

Step 6: Choose a Start Menu folder (or check ‘Do not create shortcuts’ to ignore it). Click ‘Install’ and then the installation process will begin.

Step 7: Click ‘Finish’ to complete Reports DB Tool setup.

Start DB Tool

To perform the database tool, please go to: Start > Programs > FWN-dbtool, and DB Tool utility is available for selection.

DB Tool: Tool to manage report data from the Reports database.

Fortinet: Link to Fortinet web site.

Uninstall: Uninstalls DB Tool.

Setting

The first time when you use the DB tool, please go to Setting to specify the database to be managed.

DB IP	Specify the location of the Reports database. it would be the IP address of FortiWAN Web UI.
DB Port	Specify the port number that Reports database is listening. Please use the default port 5432.
Save	Click to save the setting.

The DB tool can be used to backup, restore and delete data from FortiWAN’s Reports database.

Backup

From date	Specify the start date to back up the data by selecting a date from the drop-down calendar.
To date	Specify the end date to back up the data by selecting a date from the drop-down calendar.
Save to the directory	Click Browse to select a location where the backup data should be saved.
Delete the data after exported	Check it to delete the data in Reports database after it is backed up.
Backup	Click to start backing up the data of selected dates.

Restore

Restore

Click to select backup files to restore to database.

 

Delete

From date	Select a date from the drop-down calendar to specify the start date to delete the data.
To date	Select a date from the drop-down calendar to specify the end date to delete the data.
Delete	Click to start deleting data of selected dates.

Note that although operations that Backup and Restore data of the current date (today) are allowed, it might cause damages the report data since FortiWAN Reports is receiving and processing the data for today. Backup and Restore are strongly recommend to be used for data before today.