Maintenance is complete- We've moved from the saas.hpe.com domain to softwaregrp.com click to read more
As part of our journey to complete our separation work and our future integration with Micro Focus, we've now updated our domain for the community. This is an interim step, which will be followed by a series of future update / improvements: - Piloting Idea boards - Refreshing the entire UI. (more to come later) - and more
Quality Center / ALM Practitioners Forum
cancel

History of defects

SOLVED
Go to solution
qc_naive
Respected Contributor.

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
Highlighted
Trudy Claspill
Acclaimed Contributor.
Solution

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.)
qc_naive
Respected Contributor.

Re: History of defects

Thanks Trudy . This more or less solves my issue .