I am unable to obtain necessary details for an item that was deleted in HPQC. I have used this SQL which returned results but it was old data.
SELECT a.*
FROM Audit_Log a
where a.au_entity_id in ('38834')
and a.au_entity_type = 'BUG'
order by au_time desc
I also tried this but receive errors.
SELECT AUDIT_LOG.AU_ENTITY_ID, MAX(AUDIT_LOG.AU_TIME), AUDIT_LOG.AU_USER
AUDIT_LOG.AU_ACTION
FROM AUDIT_LOG INNER JOIN AUDIT_PROPERTIES ON AUDIT_LOG.AU_ACTION_ID = AUDIT_PROPERTIES.AP_ACTION_ID
WHERE AUDIT_LOG.AU_ENTITY_TYPE = 'BUG'
--AND AUDIT_LOG.AU_ACTION = 'UPDATE'
AND AUDIT_PROPERTIES.AP_TABLE_NAME = 'BUG'
AND AUDIT_PROPERTIES.AP_FIELD_NAME = 'BG_STATUS'
AND AUDIT_LOG. au_entity_id in ('38834')
--GROUP BY AUDIT_LOG.AU_ENTITY_ID,AUDIT_LOG.AU_USER
Any suggesitons for another Dashboard query to obtain who/when an item was deleted?
Thanks!