Audit trail delta

Document ID : KB000124435
Last Modified Date : 11/01/2019
Show Technical Document Details
Introduction:
We would like to be able to produce an Audit Trail report for a selected item and/or attribute without having to login to ALC and navigate to the item and click the "Audit Trail" tab.  How can this be done?
Environment:
CA ALC v3 and up
Instructions:
Here is a query that should work.

select b.name as user, a.createdon as update_date, c.name as field_name, a.value as field_value 
from item_attribute a 
inner join item_audit_trail d on a.ownerid = d.id and d.ownertype = 'A' 
inner join def_person b on a.createdby = b.id 
inner join def_attribute_type c on a.attributetypeid = c.id 
where d.itemid = <YOUR ITEM ID FOR THE REPORT>