Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

How to increase the row limit in Analytics output

N598231
New Contributor III
New Contributor III

Hello,

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?

2 REPLIES 2

itinjic
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

rushikeshvartak
All-Star
All-Star

You can't change this configuration due to performance issue 

rushikeshvartak_0-1715745632773.png

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

https://forums.saviynt.com/t5/identity-governance/how-can-i-run-fetch-runtime-controls-data-v2-api-t...

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.