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
Hi @sampath18 ,
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).
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.
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'