Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Require analytics table column names

Imran
New Contributor
New Contributor

 

Hi Team,

We need below attributes or columns to be fetched for the analytics report.
1 Report Schedule

2 Last Modified Date

3 Last Modified User

Is there a table that I can refer to extract?

 

Regards,

Imran Syed

4 REPLIES 4

dgandhi
All-Star
All-Star

Check analyticsconfig and analyticsconfig_history table for modified date and user.

Check qrtz_triggers for schedule

 

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

rushikeshvartak
All-Star
All-Star

Use below query

select a.ANALYTICSNAME,a.displayname,a.description,ah.FIELDNAME,ah.NEWVALUE ,ah.OLDVALUE ,ah.UPDATEDATE,u.username as updatedby  from analyticsconfig_history ah, analyticsconfig a,users u where ah.FIELDNAME like '%Schedule%' and ah.ANALYTICSCONFIGKEY=a.ANALYTICSKEY and u.userkey=ah.updateuser
 union
select a.ANALYTICSNAME,a.displayname,a.description,ah.FIELDNAME,ah.NEWVALUE ,ah.OLDVALUE,ah.UPDATEDATE,u.username as updatedby from analyticsconfiges_history ah, analyticsconfiges a,users u where ah.FIELDNAME like '%Schedule%' and ah.ANALYTICSCONFIGESKEY=a.ANALYTICSKEY and u.userkey=ah.updateuser
 

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

@Imran  Please confirm if above query worked


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Manu269
All-Star
All-Star

@Imran please use below table :

analyticsconfig_history
analyticsconfig
user table

 

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.