How to find changes made in account by a user

[sayam]

Hi,

I need to find the customer history, how many times a field value is changed and by whom this field was changed. This is more of a tracking task in Zuora. I need to get the account changes and specifically what details are edited by which user.

[Aslam]

Hi Sayam,

Are you looking for Audit Trail feature? Zuora does let you track the changes made to settings. The trail is stored in two tables which are,

• auditloginevent
• auditsettingchangeevent

Data Query is used to retrieving the information and currently, the feature is only limited to the following,

• Track, log and report on a user’s login history
• Track, log and report on setting changes of Billing, Payment, Commerce, and Finance.
• Track, log and report on activities in user management settings.

[sayam]

Hi Aslam,

Thanks for this info. Can I track with this, the exact changes and the user who made these changes?

Say, a custom field 'Autopost' for account object was recently updated from 'No' to 'Yes'. I need to figure who and when did that along with some other use cases ?