cancel
Showing results for 
Search instead for 
Did you mean: 
ArchivedThis topic has been archived. Information and links in this thread may no longer be available or relevant. If you have a question create a new topic by clicking here and select the appropriate board.
MichonR
New member
1 0 0 0
Message 1 of 2
1,809
Flag Post

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

HP Recommended
HP Quality Center 10.00
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!

0 Kudos
1 REPLY 1
Dennis_Handly
Level 7
1,515 1,503 29 63
Message 2 of 2
Flag Post
HP Recommended

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

0 Kudos
ArchivedThis topic has been archived. Information and links in this thread may no longer be available or relevant. If you have a question create a new topic by clicking here and select the appropriate board.
† 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