Anybody knows what is the table name of Audit Trail? I want to create a report using that to be able to make search on specific request. (We spend a lot of time searching using the CA SLCM).
Thanks a lot!
The audit trail data is stored within usm_system_change. Following is the query used to populate the same:
select sc.id as sc_id, sc.name as sc_name, sc.type as sc_type, sc.user_id as user_id, sc.timestamp as sc_timestamp, sc.domain as domain, sc.object_id
from usm_system_change sc
where (object_id='<request id>' and ( name like 'CAT_REQ_%'or name like 'CAT_REQ_EMAIL')) or object_id in ( select id from usm_subscription_detail where request_id=<request id> )
and ( name like 'BILL_SUBSCRIPTION_%' or name like 'FORM_ITEM_CHANGE')
order by sc.timestamp desc
Thanks a lot Jason_Wolfe
You are most welcome!
Retrieving data ...