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:


Table of Contents

Administration Guide

CLI commands for troubleshooting example

The following table provides a list of CLI commands to troubleshoot an empty chart in a report:

Command

Description

Check report running/pending status diagnose report status {running | pending}
Debug sql query

diagnose debug enable

diagnose debug application sqlplugind 4  -----errors only

diagnose debug application sqlplugind 8

List current SQL process diagnose sql process list
Configure global report automatic cache setting config system report auto-cache
List report schedule/auto-cache status by ADOM execute sql-report list-schedule <ADOM-name>
Diagnose report hcache working status diagnose test application sqlrptcached 2
Check individual report hcache status execute sql-report hcache-check <ADOM-name> <schedule-id>
Check report status during report running

diagnose debug enable

diagnose sql status sqlreportd

CLI commands for troubleshooting example

The following table provides a list of CLI commands to troubleshoot an empty chart in a report:

Command

Description

Check report running/pending status diagnose report status {running | pending}
Debug sql query

diagnose debug enable

diagnose debug application sqlplugind 4  -----errors only

diagnose debug application sqlplugind 8

List current SQL process diagnose sql process list
Configure global report automatic cache setting config system report auto-cache
List report schedule/auto-cache status by ADOM execute sql-report list-schedule <ADOM-name>
Diagnose report hcache working status diagnose test application sqlrptcached 2
Check individual report hcache status execute sql-report hcache-check <ADOM-name> <schedule-id>
Check report status during report running

diagnose debug enable

diagnose sql status sqlreportd