Fortinet Document Library

Version:


Table of Contents

Cookbook

6.2.0
Download PDF
Copy Link

Report performance troubleshooting commands

CLI Description

diagnose debug application sqlrptcached 8

Set the debug level of the SQL report cache daemon.

diagnose debug crashlog read

Print information of all crashed daemons.

If daemons crash frequently, contact customer support for assistance.

diagnose debug disable

Disable debug message.

diagnose debug enable

Enable debug messages to run SQL diagnostic commands.

diagnose fortilogd lograte

Show the log receive rate.

diagnose fortilogd msgrate

Show message receive rate. One message might contain multiple logs.

diagnose log device

Show disk quota for all logging devices.

diagnose report status

Show the maximum number of pending and running reports, and the current number of pending and running reports.

diagnose test application sqlrptcached 2

Show if hcache creation is able to catch up.

diagnose sql show hcache‑size

Show the hcache size.

diagnose sql status run‑sql-rpt

List the number of log tables, hcaches, and the time to generate each chart in the report.

diagnose sql status sqlreportd

Show SQL query connections and hcache status.

execute sql-report hcache-check <ADOM> <schedule-id>

Show a specific report’s hcache status.

execuate sql-report list‑schedule <ADOM>

Show a summary table of all configured reports with their configuration status.

execuate top

List the processes running on the FortiAnalyzer system.

get system performance

Show system performance statistics such as CPU, memory, and I/O usage.

get system status

Show the system status such as platform type (hardware or VM), firmware version, system time, disk usage, and file system format.

Use this information to check if the hardware is overloaded. This information also helps you and customer support to quickly identify any issues and narrow down the investigation.

  • Ensure Version is the latest software version.
  • Check the hardware Platform Type. Consider upgrading older hardware, especially older hardware running newer software such as 5.2 or later.
  • Ensure File System is Ext4. Other file systems will likely cause performance issues.

show system report auto‑cache

Show non-default settings in the report auto-cache.

Ensure auto-cache is enabled by running these commands:

config system report auto-cache

set status enable

end

Report performance troubleshooting commands

CLI Description

diagnose debug application sqlrptcached 8

Set the debug level of the SQL report cache daemon.

diagnose debug crashlog read

Print information of all crashed daemons.

If daemons crash frequently, contact customer support for assistance.

diagnose debug disable

Disable debug message.

diagnose debug enable

Enable debug messages to run SQL diagnostic commands.

diagnose fortilogd lograte

Show the log receive rate.

diagnose fortilogd msgrate

Show message receive rate. One message might contain multiple logs.

diagnose log device

Show disk quota for all logging devices.

diagnose report status

Show the maximum number of pending and running reports, and the current number of pending and running reports.

diagnose test application sqlrptcached 2

Show if hcache creation is able to catch up.

diagnose sql show hcache‑size

Show the hcache size.

diagnose sql status run‑sql-rpt

List the number of log tables, hcaches, and the time to generate each chart in the report.

diagnose sql status sqlreportd

Show SQL query connections and hcache status.

execute sql-report hcache-check <ADOM> <schedule-id>

Show a specific report’s hcache status.

execuate sql-report list‑schedule <ADOM>

Show a summary table of all configured reports with their configuration status.

execuate top

List the processes running on the FortiAnalyzer system.

get system performance

Show system performance statistics such as CPU, memory, and I/O usage.

get system status

Show the system status such as platform type (hardware or VM), firmware version, system time, disk usage, and file system format.

Use this information to check if the hardware is overloaded. This information also helps you and customer support to quickly identify any issues and narrow down the investigation.

  • Ensure Version is the latest software version.
  • Check the hardware Platform Type. Consider upgrading older hardware, especially older hardware running newer software such as 5.2 or later.
  • Ensure File System is Ext4. Other file systems will likely cause performance issues.

show system report auto‑cache

Show non-default settings in the report auto-cache.

Ensure auto-cache is enabled by running these commands:

config system report auto-cache

set status enable

end