Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

how to know details about all saviynt tables which are not visible in data Analyzer

sampath18
Regular Contributor II
Regular Contributor II

Hi Team,

can you please guide us in finding details of saviynt db tables which are not visible from data analyser. we were running below query in v21.0 to get the coloumn names of hidden tables. But this query is no longer working v23.4. So were there any changes in latest version of saviynt and alternate way to get these tables?

Query : SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'usershistory';

Message on Saviynt screen : Operation not allowed as you are entering a value that resembles or contains SQL query

2 REPLIES 2

pruthvi_t
Saviynt Employee
Saviynt Employee

Hi @sampath18 ,

Greetings.

Some database tables are not exposed in UI and some tables have restricted to run select queries in order to not give away the sensitive data available in the tables.

The same has been mentioned in our documentation for data analyzer (refer below screenshot). 

pruthvi_t_0-1686151407133.png

 

Hope this answers your query.  For documentation link, please follow this https://docs.saviyntcloud.com/bundle/EIC-Admin-v2021x/page/Content/Chapter07-General-Administrator/D...

As per the product design, right now data analyzer supports only specific tables. Please go ahead and raise an enhancement in ideas portal (http://ideas.saviynt.com/) for additional tables. 

Product team will take a look at it and update the raised idea accordingly.

Thanks,


Regards,
Pruthvi

sampath18
Regular Contributor II
Regular Contributor II

Hi @pruthvi_t 

Thank you for the response. But my question is if we need to write some query as per business requirement those hidden tables need to be accessed.  It is not know what coloumns are avilable also in these tables.

Till v21.0 when we run following query from Analytics module we used to get coloumn names of those hidden tables. But currently this is also not working.

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'usershistory'