Post new question
Question
Reply
 
Student
Posts: 1
Member Since: ‎05-09-2017
Message 1 of 2 (1,022 Views)

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

Product Name: HP Quality Center 10.00
Operating System: Microsoft Windows 7 (64-bit)

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!

Reply
0 Kudos
Master's Graduate
Posts: 1,427
Member Since: ‎10-03-2009
Message 2 of 2 (980 Views)

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

[ Edited ]

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

† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation