Hey guys,

I need help generating an engineer report through the excel report generator in QC. The report will have the engineer responsible for the defect, defect description/ID, and the number of hours a day this person has spent on this specific defect.

Below is my SQL query that I am using to get the information I need:

Select Distinct
BG_RESPONSIBLE as "Responsible",
BG_BUG_ID as "Bug Id",
BG_SUMMARY as "Summary"
AND BG_RESPONSIBLE = 'dasarir' -- input engineer to generate report for
-- 60 day history
and au_time <= dateadd(dd,0, datediff(dd,0, getDate()))
and au_time >= dateadd(dd,0, datediff(dd,0, getDate())) - 60

My questions:
1) How can I get the full name of the person responsible for the BUG/Defect? (Need the SQL query because I have not been able to figure it out)

2) Is there any way that I can get the number of hours this specific engineer has put daily into the specific defect? (I was told that "Actual Fix Time" under the BUG table will keep track of the hours... (so 0-3 first input, then 3-5 second input etc.)

Thank you for your help.