Report for EstimatedEffort
We are creating a process for tracking KTLO time (Keeping the Lights On). We are using tasks to do this and having technicians enter their time in the Estimated Effort fields. They do two tasks; one with a title of "KTLO Time" and one with "Total Time Worked." We have created a query report that gives us each of these two tasks sorted by Owner and then by Title, but are having an issue getting totals of each type of time entered (title). Below is the Query we are using. Can someone help? The ultimate goal is to have the percentage of time we spend on KTLO.
Additional Information: We are running ServiceDesk Plus version 9016 running on a MySQL database.
SELECT taskowner.FIRST_NAME "Owner",
tskc.comment "Comments",
taskdet.TITLE "Type",
taskdet.ESTIMATEDEFFORT "Total time",
taskdet.ESTIMATEDEFFORTHOURS "Hours",
taskdet.ESTIMATEDEFFORTMINUTES "Minutes" FROM TaskDetails taskdet
LEFT JOIN SDUser taskownersdu ON taskdet.OWNERID=taskownersdu.USERID
LEFT JOIN AaaUser taskowner ON taskownersdu.USERID=taskowner.USER_ID
Left join taskcomments tskc on tskc.taskid = taskdet.taskid
LEFT JOIN TaskTypeDefinition tskdef on tskdef.TASKTYPEID = taskdet.TASKTYPEID
WHERE tskdef.TASKTYPENAME = "KTLO Time"
ORDER BY 1,3