Resolve Windows 10 related issues for your HP computers or printers by HP Windows 10 Support Center
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?
This is the wrong company for MF software. The new forum will go live on May 15.
Didn't find what you were looking for?
Ask the community