Report to track time worked
We are trying to find a way to use ServiceDesk Plus to tack time spent on a particular item. We want to be able to get a report that would give the total time worked on for this particular task and the total time the technician worked in a day. We are trying to use tasks with 2 work logs to accomplish this. One work log is for the total hours in a day the technician worked and one for the total time the technician worked on a specific item. In the end, we want a percentage of time the technician spent on this item. We have it built, but can't figure out how to report on it. This is what I have, but it doesn't break down exactly what we need.
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