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?
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>