Quality Center / ALM Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

History of defects

SOLVED
Go to Solution
Highlighted
Frequent Advisor

History of defects

Hi,

 

I need to get the history of "Assigned To " for each and every defect logged in QC.

 

Is it possible to get that by using Excel Query Report ? Please advise

 

 

2 REPLIES
Honored Contributor

Re: History of defects

Yes. Here is a query that can be used in an Excel Report in the dashboard.

 

SELECT  
  AU_USER, 
  AU_TIME, 
  AU_ENTITY_TYPE, 
  AU_ENTITY_ID,
  AP_FIELD_NAME, 
  AP_PROPERTY_NAME, 
  AP_OLD_VALUE, 
  AP_NEW_VALUE
FROM     
  AUDIT_LOG
JOIN 
  AUDIT_PROPERTIES ON AP_ACTION_ID=AU_ACTION_ID
WHERE 
  AU_ACTION='UPDATE' AND 
  AU_ENTITY_TYPE='BUG' and 
  AP_FIELD_NAME='BG_RESPONSIBLE'

 

[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
Frequent Advisor

Re: History of defects

Thanks Trudy . This more or less solves my issue .