Use these commands to import and display language translation and fonts files, and to run a SQL report once against the FortiManager system.


execute sql-report delete-font <font-name>

execute sql-report delete-lang <language-name>

execute sql-report delete-template adom-installed <adom> <language> [title]

execute sql-report delete-template device-default <dev-type> <language> [title]

execute sql-report export-lang <language-name> <service> <ip> <argument 1> <argument 2> <argument 3>

execute sql-report export-template adom-installed <adom> <service> <ip> <user> <password> <file name> [language] [title]

execute sql-report export-template device-default <dev-type> <service> <ip> <user> <password> <file name> [language] [title]

execute sql-report hcache-build <adom> <schedule-name> <start-time> <end-time>

execute sql-report hcache-check <adom> <schedule-name> <start-time> <end-time>

execute sql-report import-font <service> <ip> <argument 1> <argument 2> <argument 3>

execute sql-report import-lang <language-name> <service> <ip> <argument 1> <argument 2> <argument 3>

execute sql-report import-template <devtype> <service> <ip> <user> <password> <file name>

execute sql-report install-template <adom> <language> <service> <ip> <user> <password> <file name>

execute sql-report list <adom> [days-range] [layout-name]

execute sql-report list-fonts

execute sql-report list-lang [language]

execute sql-report list-schedule <adom> [sched-only | autocache-only | detail] [detail]

execute sql-report list-template adom-installed <adom> [language]

execute sql-report list-template device-default <dev-type> [language]

execute sql-report run <adom> <schedule-name> <start-time> <end-time>

execute sql-report view <data-type> <adom> <report-name>




Delete one font.


Delete one language translation file.


Delete templates.

  • adom-installed - Delete report templates installed in ADOM.
  • device-default - Delete device type default report templates.


Export a user-defined language translation file.


Export report templates.

  • adom-installed - Export ADOM report templates to file.
  • device-default - Export device type default report templates to file.


Build report hcache.


Check report hcache.


Import one font.


Import a user-defined language translation file.


Import per device type template from a configuration file.


Install specific language templates to an ADOM.


List recent generated reports.


List all imported fonts.


Display all supported language translation files.


List report schedule and autocache information.


List templates.

  • adom-installed - Display report templates installed in ADOM.
  • device-default - Display device type default report templates.


Run a report once.


View report data.


Specify the ADOM name.


The name of a font.


Enter the device type abbreviation:

  • FGT - FortiGate
  • FMG - FortiManager
  • FCT - FortiClient
  • FML - FortiMail
  • FWB - FortiWeb
  • FCH - FortiCache
  • FAZ - FortiAnalyzer
  • FSA - FortiSandbox
  • FDD - FortiDDoS
  • FAC - FortiAuthenticator
  • FPX - FortiProxy


Enter the language name to import, export, or delete a language translation file, or select one of the following options:

  • English
  • French
  • Japanese
  • Korean
  • Portuguese
  • Simplified_Chinese
  • Spanish
  • Traditional_Chinese


Enter the transfer protocol: ftp, sftp, scp, or tftp.

TFTP is not available for all commands.


Enter the server IP address.

<argument 1>

For FTP, SFTP, or SCP, type a user name. For TFTP, enter a file name.

<argument 2>

For FTP, SFTP, or SCP, type a password or ‘-’. For TFTP, press <enter>.

<argument 3>

Enter a file name and press <enter>.


Enter a user name for the remote server.


Enter the password, or -, for the remote server user.

<file name>

Enter the name of the file.


The data type to view: report-data or report-log.


The name of the report to view.


Select one of the available report schedule names.


The start date and time of the report schedule, in the format: "HH:MM yyyy/mm/dd"


The enddate and time of the report schedule, in the format: "HH:MM yyyy/mm/dd"


The recent n days to list reports, from 1 to 99.


One of the available SQL report layout names.


Enter the language abbreviation:

  • en - English
  • de - German
  • es - Spanish
  • fr - French
  • it - Italian
  • ja - Japanese
  • ko - Korean
  • pt - Portuguese
  • ru - Russian
  • zh - Simplified Chinese
  • zh_Hant - Traditional Chinese


Title of a specific report template.