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
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to check all records in database table - Currently maximum 10 records are displayed

Go to solution
Community_User
Saviynt Employee
Saviynt Employee

‎04/12/2022 12:55 PM

Originally posted on April 21 2020 at 14:45 UTC

Is there any way to see all the records in any database table?


I'm using analytics Preview feature to execute SQL query:


Analytics -> Analytics Configuration List -> Create New Analytics -> Using SQL Query -> adding my query in 'Analytics Query' -> click on Preview


It works for SQL queries where records are 10 or less than 10, bit it doesn't show me more than 10 even if I change the number of records to be displayed from 10 to 100 for example.


Screenshot attached

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.
0 Kudos
1 REPLY 1

Go to solution
Community_User
Saviynt Employee
Saviynt Employee

‎04/12/2022 01:52 PM

Originally posted on April 21 2020 at 14:57 UTC

Hi Ramanpreet,


Greetings!


Preview screen is designed to show only 10 records since its just a preview and does not show all records in resultset. You can actually save the control and run the control to view all records in a database table

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.
0 Kudos
Copyright © 2024 Khoros, LLC