Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

How to increase the row limit in Analytics output

New Contributor III
New Contributor III


How do I expand the number of rows displayed in the analytics report results? Presently, it only shows 5000 rows, yet the query fetches more. Could we introduce pagination to streamline data retrieval in analytics reports?


Regular Contributor
Regular Contributor

To expand the number of rows displayed in the analytics report results, you can increase the value of the "Ws_max_records_returned_analytics_es" configuration in Saviynt. By default, this configuration limits the number of rows returned in an analytics report to 5000.

To increase this limit, you can follow these steps:

1. Login to the Saviynt Admin portal.

2. Navigate to the Admin section.

3. Search for the "Ws_max_records_returned_analytics_es" configuration.

4. Select the configuration, and update the value to the desired number of rows you want to display. For example, you can set it to 10000 to display 10000 rows in the analytics report.

5. Save the configuration changes and restart the Saviynt application for the changes to take effect.

Once you have updated the configuration, you should be able to view a higher number of rows in the analytics report results.

Regarding pagination, Saviynt does support pagination in analytics reports. You can specify the number of rows to be fetched per page using the "size" parameter in the API request. By default, the size is set to 500. You can increase this value to fetch a larger number of rows per page. Additionally, you can use the "from" parameter to specify the starting index of the records to fetch, allowing you to navigate through different pages of the result set.

By utilizing pagination, you can streamline data retrieval in analytics reports and fetch the required number of rows based on your needs.

Sapere aude


You can't change this configuration due to performance issue 


select * from configuration where name like '%MAX_RECORDS%'


Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.