Fortinet Document Library

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:


Table of Contents

CLI Reference

sql-local

Use this command to remove the SQL database and logs from the FortiAnalyzer system and to rebuild the database and devices.

When rebuilding the SQL database, new logs will not be available until the rebuild is complete. The time required to rebuild the database is dependent on the size of the database. Please plan a maintenance window to complete the database rebuild. You can use the diagnose sql status rebuild-db command to display the SQL log database rebuild status.

The following features will not be available until after the SQL database rebuild has completed: FortiView, Log View, Event Management, and Reports.

Syntax

execute sql-local rebuild-adom <adom> ... <adom>

execute sql-local rebuild-db

execute sql-local rebuild-index <adom> <start-time > <end-time>

execute sql-local remove-db

Variable

Description

rebuild-adom

Rebuild log SQL database from log data for particular ADOMs.

rebuild-db

Rebuild entire log SQL database from log data.

rebuild-index

Rebuild indexes for an ADOM.

remove-db

Remove the entire local SQL database.

<adom>

The ADOM name. Multiple ADOM names can be entered.

<start-time >

Enter the start time (timestamp or <yyyy-mm-dd hh:mm:ss>).

<end-time>

Enter the end time (timestamp or <yyyy-mm-dd hh:mm:ss>).

<log type>

Enter the log type from available log types. For example: emailfilter

sql-local

Use this command to remove the SQL database and logs from the FortiAnalyzer system and to rebuild the database and devices.

When rebuilding the SQL database, new logs will not be available until the rebuild is complete. The time required to rebuild the database is dependent on the size of the database. Please plan a maintenance window to complete the database rebuild. You can use the diagnose sql status rebuild-db command to display the SQL log database rebuild status.

The following features will not be available until after the SQL database rebuild has completed: FortiView, Log View, Event Management, and Reports.

Syntax

execute sql-local rebuild-adom <adom> ... <adom>

execute sql-local rebuild-db

execute sql-local rebuild-index <adom> <start-time > <end-time>

execute sql-local remove-db

Variable

Description

rebuild-adom

Rebuild log SQL database from log data for particular ADOMs.

rebuild-db

Rebuild entire log SQL database from log data.

rebuild-index

Rebuild indexes for an ADOM.

remove-db

Remove the entire local SQL database.

<adom>

The ADOM name. Multiple ADOM names can be entered.

<start-time >

Enter the start time (timestamp or <yyyy-mm-dd hh:mm:ss>).

<end-time>

Enter the end time (timestamp or <yyyy-mm-dd hh:mm:ss>).

<log type>

Enter the log type from available log types. For example: emailfilter