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

Certification export query needed

Jaya
Regular Contributor II
Regular Contributor II

Hi All,

I need the query that we are using while exporting a certification. Or just the name of attribute that we are using for 'history' column in the export.

 

Jaya_0-1659349310828.png

Thanks

Jaya

Thanks
Jaya Karothia
4 REPLIES 4

rushikeshvartak
All-Star
All-Star

Table Name : certification_user_status 

Column Name : AUDITTRAIL

 

rushikeshvartak_0-1659376560661.png

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Jaya
Regular Contributor II
Regular Contributor II

Thanks a lot Rushikesh for this .

It would be great if you can help me in one more thing-

If you can see below screenshot the 'history' column only contains the Employee ID of the consulted user. Can we add Display name instead of this Emp ID.

Jaya_0-1659439505946.png

 

Thanks

Jaya

Thanks
Jaya Karothia

No. This report are built using saviynt code & if we don't have strong justification behind it then saviynt won't change. 

 

In short we can't change  however if needed you can create OOTB analytics report


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Jaya
Regular Contributor II
Regular Contributor II

Although we have raised an FD enhancement ticket for this, lets see when we got the solution.

 

Thanks

Jaya karothia 

Thanks
Jaya Karothia