Introduction
While the Time Machine Audit tab allows you to search, sort, and filter using the GRAX Time Machine Index metadata, the Advanced Audit tab will take this to the next level by allowing you to actually pull the underlying field-level data directly from the historical version and visualize this as a column. Now you can have the metadata about the change event as well as the actual data from the underlying record side by side.
Instructions
Let's take a look at the steps involved:
Note that you can only run Advanced Audit queries for one object at a time
Step 1: Details
The Details
section is the same as the Audit
tab. This will allow you to select the columns from the Time Machine Index that you want to display in your retrieved results. Remember the options here will not show all the underlying fields from the object.
Step 2: Filter Records
This is where you can add columns to your results from an underlying object. You must first select a single object to filter on, and then you will see the fields from that object that you want to add.
If you want to add filter logic, be aware that these filters must be on the Time Machine Index fields (not underlying fields from SFDC object). Essentially, you are filtering on the Time Machine Index metadata, but you can also see the SFDC object data from this version side-by-side.


Here's an example where we are using the Advanced Audit functionality to find all Account time machine events where BillingCity was one of the FieldsModified
Step 3: Retrieve Results
Once we click retrieve, you will see a list of all Time Machine Index results found. The columns will be a mix of metadata from the Time Machine Index as well as fields from the underlying object that you selected.
Similar to the Audit tab, you can click the "Eye" icon to drill deeper into this historical change event and see all fields that were modified, original values, changed values, current values etc.


You can see clearly here the metadata columns representing information regarding the time machine event, side-by-side with the data of the underlying record. We can see a list of all Accounts where BillingCity was changed, and we can also see the underlying field data for these historical versions such as Active, Industry, and Account Fax.
Updated 9 months ago