Skip to navigation
Security and identityAudit TrailAudit Trail using Data QuerySample Queries of Audit Trail

Retrieve the setting changes

View as Markdown

Learn how to retrieve setting change records using a data query job.

The following use case retrieves the setting change records.

1

Submit a data query job through UI or API with the following SQL query:

SELECT username      AS UpdatedBy, 
       action        AS Action, 
       settingtype   AS SettingType, 
       attributename AS Attribute, 
       oldvalue      AS OldValue, 
       newvalue      AS NewValue, 
       timestamp     AS Timestamp 
FROM   auditsettingchangeevent 
WHERE  namespace <> 'UserManagement' 
       AND year = 2022
       AND month = 11
ORDER  BY timestamp DESC 
LIMIT  100000
2

Check the status of the query job through UI or API operation. For more inforamtion on how to retrieve a data query job using API, see .Retrieve a data query job

3

Download the query result when the job is completed. See the following snippet of the query result.

UpdatedBy,Action,SettingType,Attribute,OldValue,NewValue,Timestamp
audit-trail@zuora.com,UPDATED,TenantProperty,PROPERTY_DISALLOW_BLANK_ACCOUNTING_CODE,false,true,2022-11-10T09:30:52Z
audit-trail@zuora.com,UPDATED,TenantProperty,PROPERTY_DISALLOW_BLANK_ACCOUNTING_CODE,true,false,2022-11-10T09:29:47Z
audit-trail@zuora.com,UPDATED,BillingRules,Enable credit back for removing or canceling one time charges?,false,true,2022-11-05T17:08:53Z
audit-trail@zuora.com,UPDATED,BillingRules,"When prorating a month, assume 30 days in a month or use actual days?",Assume30Days,UseActualDays,2022-11-05T17:08:53Z
audit-trail@zuora.com,UPDATED,BillingRules,Support bill run auto-post?,true,false,2022-11-05T17:08:53Z
audit-trail@zuora.com,UPDATED,BillingRules,"When prorating periods greater than a month, prorate by month first, or by day?",ProrateByDay,ProrateByMonthFirst,2022-11-05T16:56:36Z
audit-trail@zuora.com,UPDATED,BillingRules,"When prorating a month, assume 30 days in a month or use actual days?",UseActualDays,Assume30Days,2022-11-05T16:56:36Z
audit-trail@zuora.com,UPDATED,BillingRules,includeNegativeInvoice,false,true,2022-11-05T16:56:36Z
audit-trail@zuora.com,UPDATED,BillingRules,Enable credit back for removing or canceling one time charges?,true,false,2022-11-05T16:56:36Z