AnsweredAssumed Answered

Audit Table Query

Question asked by lockhartb on Jul 28, 2014
Latest reply on Jul 31, 2014 by urmas

I am trying to write a query that will produce a list of records deleted in the last 24 hours. I notice that the LAST_UPDATED_DATE field seems to be populated with when the object (let's use a Status Report for example) was last modified, not whe the Status itself was deleted. In Clarity 13.0.

 

Here is a screenshot:

auditquery.png

 

I need to know when the record was deleted for this query to work correctly. I notice in the Audit trail on the Project that the date the delete took place is captured, so it has to be in there somewhere.

 

 

Ideas?

 

 

Thanks,

 

Ben

Outcomes