IBM Support

Why are only 30,000 rows in exported to csv from Guardium GUI report?

Troubleshooting


Problem

When exporting GUI reports as csv file, there is a default maximum limit of 30,000 rows

Symptom

Export a GUI report (Export > Download all records) that contains more than 30000 rows. Once the spreadsheet is opened, it contains only 30,000 rows.

Resolving The Problem

There are a few methods to resolve this:

1. Change the limit using CLI command "store csv_max_size XXX" where XXX is the maximum size, then restart the GUI using "restart gui"

2. Set up an Audit Process and export the file. There is no limit on the number of rows that are exported from Audit Processes.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General Information","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.0;10.0.1;10.1;10.1.2","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21996329