Report for time spent by technician on tasks

Report for time spent by technician on tasks

Hi,

I'd like to obtain a report on task to show the time spent by technician, and the actual hours vs estimated hours.

The default report template for tasks shown below doesn't include that fields:


SELECT "taskmilestone"."PROJECTID" AS "ID del proyecto", "taskdet"."TASKID" AS "ID de la tarea", "taskdet"."TITLE" AS "Título", "taskcreatedby"."FIRST_NAME" AS "Creado por", "taskowner"."FIRST_NAME" AS "Propietario", "taskdet"."PER_OF_COMPLETION" AS "Porcentaje de finalización", "taskdet"."ADDTIONAL_COST" AS "Coste adicional", "taskdet"."CREATEDDATE" AS "Fecha de creación", "taskdet"."SCHEDULEDSTARTTIME" AS "Hora de inicio programada", "taskdet"."SCHEDULEDENDTIME" AS "Hora de finalización programada", "taskdet"."ACTUALSTARTTIME" AS "Hora de inicio real", "taskdet"."ACTUALENDTIME" AS "Hora de finalización real", "taskdet"."MODULE" AS "Módulo", "taskprior"."PRIORITYNAME" AS "Prioridad", "taskstatus"."STATUSNAME" AS "Estado de la tarea", "tasktype"."TASKTYPENAME" AS "Tipo de tarea", "taskgroup"."QUEUENAME" AS "Grupo", "wotask"."WORKORDERID" AS "ID de la solicitud", "wotask"."TITLE" AS "Título de la solicitud", "taskprob"."PROBLEMID" AS "ID de problema", "taskprob"."TITLE" AS "Título del problema", "taskchange"."CHANGEID" AS "ID de cambio", "taskchange"."TITLE" AS "Cambiar título", "taskproject"."PROJECTID" AS "ID del proyecto", "taskproject"."TITLE" AS "Título del proyecto", "taskmilestone"."MILESTONEID" AS "ID del acontecimiento importante", "taskmilestone"."TITLE" AS "Título del acontecimiento importante", "taskdet"."ISESCALATED" AS "Derivado", "taskdet"."ISOVERDUE" AS "Estado vencido"  FROM "TaskDetails" "taskdet" LEFT JOIN "AaaUser" "taskcreatedby" ON "taskdet"."CREATEDBY"="taskcreatedby"."USER_ID" LEFT JOIN "SDUser" "taskownersdu" ON "taskdet"."OWNERID"="taskownersdu"."USERID" LEFT JOIN "AaaUser" "taskowner" ON "taskownersdu"."USERID"="taskowner"."USER_ID" LEFT JOIN "PriorityDefinition" "taskprior" ON "taskdet"."PRIORITYID"="taskprior"."PRIORITYID" LEFT JOIN "StatusDefinition" "taskstatus" ON "taskdet"."STATUSID"="taskstatus"."STATUSID" LEFT JOIN "TaskTypeDefinition" "tasktype" ON "taskdet"."TASKTYPEID"="tasktype"."TASKTYPEID" LEFT JOIN "QueueDefinition" "taskgroup" ON "taskdet"."GROUPID"="taskgroup"."QUEUEID" LEFT JOIN "WorkOrderToTaskDetails" "wototaskdet" ON "taskdet"."TASKID"="wototaskdet"."TASKID" LEFT JOIN "WorkOrder" "wotask" ON "wototaskdet"."WORKORDERID"="wotask"."WORKORDERID" LEFT JOIN "ProblemToTaskDetails" "probtotaskdet" ON "taskdet"."TASKID"="probtotaskdet"."TASKID" LEFT JOIN "Problem" "taskprob" ON "probtotaskdet"."PROBLEMID"="taskprob"."PROBLEMID" LEFT JOIN "ChangeToTaskDetails" "changetotaskdet" ON "taskdet"."TASKID"="changetotaskdet"."TASKID" LEFT JOIN "ChangeDetails" "taskchange" ON "changetotaskdet"."CHANGEID"="taskchange"."CHANGEID" LEFT JOIN "TaskToProjects" "projtotaskdet" ON "taskdet"."TASKID"="projtotaskdet"."TASKID" LEFT JOIN "ProjectDetails" "taskproject" ON "projtotaskdet"."PROJECTID"="taskproject"."PROJECTID" LEFT JOIN "TaskToProjects" "miletotaskdet" ON "taskdet"."TASKID"="miletotaskdet"."TASKID" LEFT JOIN "MileStoneDetails" "taskmilestone" ON "miletotaskdet"."MILESTONEID"="taskmilestone"."MILESTONEID" LEFT JOIN "TaskToProjects" ON "taskdet"."TASKID"="TaskToProjects"."TASKID" LEFT JOIN "ProjectAccMapping" ON "TaskToProjects"."PROJECTID"="ProjectAccMapping"."PROJECTID" LEFT JOIN "AccountSiteMapping" ON "taskdet"."SITEID"="AccountSiteMapping"."SITEID" WHERE  (("taskdet"."MODULE" COLLATE Modern_Spanish_CS_AI = N'general') OR (("ProjectAccMapping"."ACCOUNTID" IN (3006,446,448,450,452,454,3601,456,4801,1,458,460,591,1503,462,464,3305,601,466,468,510,470,1215,472,474,476,478,480,482,484,486,488,1506,490,492,494,4201,496,568,5401,498,500,502,504,506,2401,508,512,514,516,518,520,522,524,526,528,3303,530,532,534,536,5101,3012,589,5107,538,540,542,544,546,548,550,552,3008,2701,3010,554,3901,556,604,593,558,3307,560,562,564,4203,3001,5105,5103,566,570,572,3301,574,576,578,4501,4205,1801,1501,581,583,585,587,4803,3003)) OR ("AccountSiteMapping"."ACCOUNTID" IN (3006,446,448,450,452,454,3601,456,4801,1,458,460,591,1503,462,464,3305,601,466,468,510,470,1215,472,474,476,478,480,482,484,486,488,1506,490,492,494,4201,496,568,5401,498,500,502,504,506,2401,508,512,514,516,518,520,522,524,526,528,3303,530,532,534,536,5101,3012,589,5107,538,540,542,544,546,548,550,552,3008,2701,3010,554,3901,556,604,593,558,3307,560,562,564,4203,3001,5105,5103,566,570,572,3301,574,576,578,4501,4205,1801,1501,581,583,585,587,4803,3003)))) 


Is there any way to show time spent fields?

Thanks.

Version:  9.2 Build 9205
Database:      MSSQL



              New to ADManager Plus?

                New to ADSelfService Plus?