05-09-2017 11:18 AM
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.
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
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?
05-13-2017 09:22 PM
This is the wrong company for HPE software. The new forum will go live on May 15.