Query to export time spend report
Hi Team,
we need an report for time spend in all the modules ( IR , SR , CR, PID) & Generic task as well with available coloums listed below.. please share the query asap
Time Spent
Request ID (Incident & Service Request)
CHange Request ID
Problem Request ID
Task (Generic)
Employee ID
Technician Name
Group
Site
Created Time
Regards
Rajeesh