Hi, I am looking for an option where I can have an audit log report from each section.
Pls, let me know how can I achieve this?
I have even tried it with SQL but am still not able to fetch any reports through it .
Like
Hello Bhumika,
Unfortunately, there is no possibility to export data directly from the Changelog object at the moment. We have already registered the project for our R&D team to review the possibility of implementing an export feature for the Changelog data.
As a temporary workaround, data can be exported directly from the database. This information is stored in the Sys[object name]Log table.
Best regards,
Bogdan
Hi thanks for the updates this works well for us but I am having a problem reading these audit logs I am attaching a few screenshots pls tell me to know what is changetypeId and how can I map it with my actual logs plus let me know where and how can I read new and old values and which table it belongs ???
Bogdan,
Bogdan writes:
Hello Bhumika,
Unfortunately, there is no possibility to export data directly from the Changelog object at the moment. We have already registered the project for our R&D team to review the possibility of implementing an export feature for the Changelog data.
As a temporary workaround, data can be exported directly from the database. This information is stored in the Sys[object name]Log table.
Best regards,
Bogdan
+ 1 for the capability of exporting logs into 3rd party systems for analysis. Has been asked from a couple high profile prospects (large entities and public sector)