Finding who/when a defect/CR was deleted, need good SQL for HP Quality Center

[MichonR]

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!

[Dennis_Handly]

This is the wrong company for MF software. The new forum will go live on May 15.

https://community.softwaregrp.com/t5/Quality-Center-ALM-Practitioners/bd-p/itrc-895