> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Sample Queries of Audit Trail

> This topic provides guidance on retrieving Audit Trail records using Data Query, including sample queries.

This topic provides guidance on retrieving Audit Trail records using Data Query, including sample queries.

The Audit Trail records are stored in the following tables:

You must retrieve Audit Trail records through Data Query. For more information on data query, see [Overview of Data Query](/docs/platform/data/data-query/overview-of-data-query) .

* `auditloginevent`
* `auditsettingchangeevent`
* `auditobjectchangeevent`

See the following samples on how to generate Audit Trail reports.

## Retrieve jobs performed through the Data Loader

The following use cases retrieve auditing records of changes to a job performed through the Data Loader.

Example 1:

```
SELECT *
FROM   auditobjectchangeevent
WHERE  namespace = 'BulkData'
ORDER  BY timestamp DESC 
LIMIT  100
```

Example 2:

```
SELECT *
FROM   auditobjectchangeevent
WHERE  namespace = 'BulkData'
        AND YEAR = 2023
        AND MONTH = 8
        AND DAY = 7
ORDER  BY timestamp DESC 
LIMIT  100
```

## Retrieve jobs performed through the Deployment Manager

The following query retrieves the details of the job performed through Deployment Manager

```
SELECT * 
FROM auditobjectchangeevent 
WHERE Month=10 and Year=2024
```

## Note

To get high-performance queries, always use the `year` , `month` , or `day` fields in the WHERE clause of a SQL query when exporting Audit Trail records through Data Query.

> This topic provides guidance on retrieving Audit Trail records using Data Query, including sample queries.

## Docs

- [Retrieve the login history](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-the-login-history.md): Learn how to retrieve login history records by submitting a data query job with SQL, checking the job status, and downloading the results.
- [Retrieve the setting changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-the-setting-changes.md): Learn how to retrieve setting change records using a data query job.
- [Retrieve the user management setting changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-the-user-management-setting-changes.md): Learn how to retrieve user management setting change records using a data query job.
- [Retrieve Account changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-account-changes-part-2.md): Learn how to retrieve auditing records of Account changes, including updates to BillToId and SoldToId values.
- [Retrieve Product Catalog changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-product-catalog-changes.md): Learn how to retrieve auditing records of changes to the Product Catalog object hierarchy using a data query job.
- [Retrieve Chase Orbital Payment Gateway changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-chase-orbital-payment-gateway-changes.md): Learn how to retrieve auditing records of changes to the Chase Orbital payment gateway configuration using a data query.
- [Retrieve Notification Definition changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-notification-definition-changes.md): Learn how to retrieve auditing records of changes to the Notification Definition object using a data query job.
- [Retrieve Workflow changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-workflow-changes.md): Learn how to retrieve auditing records of changes to the Workflow definition object hierarchy using a data query.
- [Retrieve Custom Logic changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-custom-logic-changes.md): Learn how to retrieve auditing records of changes to Custom Logic objects, including decision tables, decision trees, and functions, using a data query.
- [Retrieve custom field definition changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-custom-field-definition-changes.md): Learn how to retrieve auditing records of changes to custom field definitions using a data query.
- [Retrieve custom object changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-custom-object-changes.md): Learn how to retrieve auditing records of changes to custom objects, including definitions and records, using a data query.
- [Retrieve Order Action Changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-order-action-changes.md): This task guides you through querying order action changes using a data query job via UI or API.
- [Retrieve Order changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-order-changes-1.md): This task guides you through retrieving auditing records of changes to order changes using a data query.
- [Retrieve Subscription Changes](https://zuora.ferndocs.com/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/sample-queries-of-audit-trail/retrieve-subscription-changes.md): Learn how to track changes in subscription versions using data queries.