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

Data Analyzer Max Results Increase

JFrance
New Contributor II
New Contributor II

Hi Saviynt, 

I am trying to export some data using the data analyzer but my SQL query is getting capped at 100 results. Is there a way to get around this cap so I can export the full results of the query rather than the 100 top results?

Thanks in advance!

4 REPLIES 4

Amit_Malik
Valued Contributor II
Valued Contributor II

Hi @JFrance ,

You can create an SQL query analytics using same query and get the result in form of email. 

Br, Amit

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".

JFrance
New Contributor II
New Contributor II

Is there documentation on how to do this?

Amit_Malik
Valued Contributor II
Valued Contributor II

This should have all that you need - https://docs.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Chapter16-SSM-Analytics/Managing-An...

Thanks,

Amit

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".

rushikeshvartak
All-Star
All-Star
  • Create an analytics report and extract records 
  • Navigate to Intelligence > Analytics Configurations List
  • Click Create New Analytics.

  • Select Using SQL Query. The Create New Analytics Configuration page is displayed.

  • If the SQL query that you entered in the control configuration, returns more than or equal to ten records, then the analytics preview displays all the ten records. If the query returns less than ten records, the preview displays those many numbers of records.

  • The Preview button is enabled before you click the Create button. Once the analytics control is created, you cannot view the Preview button.

  • The Preview button is used to validate the correctness of the query syntax and to display the first 10 rows of the result data. This does not validate columns in the analytics query for the allowed action. An error message is displayed if the query syntax is incorrect. You can view the error details from the log files or by executing the same query directly in the database.

  • The Create button must be used as the final step in the creation of the analytics control. This validates the mandatory columns in the analytics query for the allowed action. You will be able to select the visible and filterable columns for the control and submit the control creation only if all validations are complete.

  • rushikeshvartak_0-1707255186187.png

     

https://docs.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Chapter16-SSM-Analytics/Managing-An...


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