Audit trail delta
Article ID: 124435
Updated On:
Products
Application Lifecycle Conductor
Issue/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
Resolution
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>
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>
Feedback
Yes
No
Powered by
