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:
|
<service> |
Enter the transfer protocol: |
<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-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: |
<end-time> |
The enddate and time of the report schedule, in the format: |
[days-range] |
The recent n days to list reports, from 1 to 99. |
[layout-name] |
One of the available SQL report layout names. |