Report with time spent

Report with time spent

Hi,

I´m trying to create a custom  report to show the below informations:

Request ID
Technician
Category
Subcategory
Item 
Total of Time Spent in each request (sum of time taken to resolve)

But I dont have all these fields when I try to create a report.

Could someone help me to create a query report with these fileds? (MS-SQL)

Thanks a lot

Paulo Santos


                New to ADManager Plus?

                  New to ADSelfService Plus?