Creating reports for connection history, workflow history, campaign config updates

[sreehariv]

Hi Team,

is there any possibility with in Saviynt for implementing the below requirements.

1. Can we write a query to export the connection history and combine all the connections in one report if possible
2. Can we write a query to export all the workflow history in a customized report
3. Can we write a query to export history of updates in configuration to a particular campaign

Thanks

Sreehari

[Dhruv_S]

Hi @sreehariv , Thanks for contacting the Saviynt forums. Our team is reviewing this requirement, and we will keep you informed.

[Dhruv_S]

Hi @sreehariv ,

You can refer to some of the queries mentioned in below posts and modify according to your requirements.

All Active Connection Details

https://forums.saviynt.com/t5/saviynt-knowledge-base/standard-report-queries/ta-p/50282 

Workflow History

Solved: Data table for workflow history - Saviynt Forums - 49340

Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.

[sreehariv]

Hello Team,

Is there any possibility for the below. We can see from UI -> Campaign Template we can export the particular template changes from history but can we do the following from analytics

1. Can we write a query to export history of updates in configuration to a particular campaign

[Dhruv_S]

Hi @sreehariv Campaign template history can be exported from UI Itself from Campaign template ->history-export. For SQL query you can refer to tables campaign_template, campaign which contains columns like CREATEDATE, UPDATEDATE, UPDATEBY.