Audit trail delta

Document ID : KB000124435
Last Modified Date : 11/01/2019
Show Technical Document Details
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?
CA ALC v3 and up
Here is a query that should work.

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