Chapter: execute > sql-report

sql-report

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

Syntax

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

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 <name> <service> <ip> <argument 1> <argument 2> <argument 3>

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

execute sql-report list-fonts

execute sql-report list-lang

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

execute sql-report run <adom> <schedule-name> <num-threads>

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

Variable

Description

del-font

Delete one font.

hcache-build

Build report hcache.

hcache-check

Check report hcache.

import-font

Import one font.

import-lang

Import a user-defined language translation file.

list

List recent generated reports.

list-fonts

List all imported fonts.

list-lang

Display all supported language translation files.

list-schedule

List report schedule and autocache information.

run

Run a report once.

view

View report data.

<font-name>

The name of a font.

<name>

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

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

<service>

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

<ip>

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>.

<adom>

Enter the ADOM name to run the report.

<data-type>

The data type to view. Must be report-data.

<report-name>

The name of the report to view.

<schedule-name>

Select one of the available report schedule names.

<num-threads>

Select the number of threads.

<start-time>

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

<end-time>

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

[days-range]

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

[layout-name]

One of the available SQL report layout names.