If you are running a large number of reports which are very similar, you can significantly improve report generation time by grouping the reports. Grouping reports has these advantages:
- Reduce the number of hcache tables.
- Improve auto-hcache completion time.
- Improve report completion time.
Step 1: Configure report grouping
For example, to group reports with titles containing string
Security_Report by device ID and VDOM, enter the following CLI commands:
config system report group
set adom root
set report-like Security_Report
report-likefield specifies the string in report titles that is used for report grouping. This string is case-sensitive.
group-byvalue controls how cache tables are grouped.
- To view report grouping information, enter the following CLI command, then check the Report Group column of the table that is displayed.
execute sql-report list-schedule <ADOM>
Step 2: Initiate a rebuild of hcache tables
To initiate a rebuild of hcache tables, enter the following CLI command:
diagnose sql hcache rebuild-report <start-time> <end-time>
<end-time> are in the format: