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.
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.
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.
|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||Click to select backup files to restore to database.|
|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.
Having trouble configuring your Fortinet hardware or have some questions you need answered? Ask your questions in the comments below!!! Want someone else to deal with it for you? Get some consulting from Fortinet GURU!