Configuring number of rows in a tabular report for email or export
When you export, email, or schedule a tabular report, 4000 rows are exported by default.
You can configure the maximum number of rows in a tabular report that you can export or email.
To configure the maximum number of rows for export
- Log on to the OpsCenter Server.
- Stop all the OpsCenter Server services or processes by using the following commands on Windows and UNIX:
Windows
INSTALL_PATH\OpsCenter\server\bin\opsadmin.bat stop
UNIX
<INSTALL_PATH>/SYMCOpsCenterServer/bin/opsadmin.sh stop
- Navigate to the following location:
Windows
C:\Program Files\Symantec\OpsCenter\server\config
UNIX
<INSTALL_PATH>/SYMCOpsCenterServer/config
- Open the
report.conffile. - You may want to export all the rows or you may want to increase or decrease the maximum value. Note that if you export all rows or increase the number of rows, exporting a report may take time when there are a large number of rows.
To export all the rows, you can either comment out report.schedule.max.tabular.rows parameter or specify any value less than or equal to -1 for report.schedule.max.tabular.rows parameter.
To comment out report.schedule.max.tabular.rows parameter, add two forward slashes before the parameter in this manner: //report.schedule.max.tabular.rows=4000
or
Edit the value 4000 in report.schedule.max.tabular.rows=4000 to -1.
report.schedule.max.tabular.rows=-1
To change the maximum number of rows to say 5000, you can set the value of report.schedule.max.tabular.rows as 5000.
Configure report.schedule.max.tabular.rows=5000
- Start all OpsCenter Server services or processes by using the following command for Windows and UNIX:
Windows
INSTALL_PATH\OpsCenter\server\bin\opsadmin.bat start
UNIX
<INSTALL_PATH>/SYMCOpsCenterServer/bin/opsadmin.sh start