home

Zuora Platform

Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies
Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies

Welcome to Zuora Product Documentation

Explore our rich library of product information

Show Contents

thumbnailZuora Platform

Sample Queries of Audit Trail

Retrieve Subscription Changes

Learn how to track changes in subscription versions using data queries.

For multiple-versioned subscriptions, audit trail treats each version of a subscription and rate plan charge as a distinct object. So, you can track the changes of a specific version identified by ID, instead of all the changes throughout the subscription lifecycle. This is an example of querying subscription custom field value changes by subscription id:

  1. Submit a data query job through UI or API with the following SQL query: 
    SELECT username    AS Username,
       action      AS Action,
       objecttype  AS ObjectType,
       objectname  AS ObjectName,
       objectid    AS ObjectId,
       attributeid AS Attribute,
       oldvalue    AS OldValue,
       newvalue    AS NewValue,
       timestamp   AS Timestamp 
FROM   auditobjectchangeevent 
WHERE  objecttype = 'Subscription' 
       AND action = 'UPDATED' 
       AND objectid = '86d4889a19b9ae883a5afbdfaafe021c'
ORDER  BY timestamp DESC, transactionid
LIMIT  100
  2. Check the status of the query job through UI or Get data query job API operation.
  3. Download the query result when the job is completed. See the following example of the query result.
    Username,Action,ObjectType,ObjectName,ObjectId,Attribute,OldValue,NewValue,Timestamp
user@company.com,UPDATED,Subscription,A-S00148280,86d4889a19b9ae883a5afbdfaafe021c,state__c,,New Jersey,2025-12-08T03:12:39Z

Last updated: December 16, 2025