Problem time spent

Problem time spent

       prob.TITLE "Title",
       catadef.CATEGORYNAME "Category",
       LONGTODATE(prob.REPORTEDTIME) "Reported Date",
       ownaaa.FIRST_NAME "Technician",
       priodef.PRIORITYNAME "Priority",
       statdef.STATUSNAME "Status",
       (chargestable.TimeSpent/1000/3600) "Time Spent",
       chargestable.Description "WorkLog description",
       pct.FIRST_NAME "WorkLog tech" FROM Problem prob
LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID
LEFT JOIN StatusDefinition statdef ON prob.STATUSID=statdef.STATUSID
LEFT JOIN PriorityDefinition priodef ON prob.PRIORITYID=priodef.PRIORITYID
LEFT JOIN CategoryDefinition catadef ON prob.CATEGORYID=catadef.CATEGORYID
LEFT JOIN problemtocharge ON prob.PROBLEMID=problemtocharge.PROBLEMID
LEFT JOIN ChargesTable ON problemtocharge.CHARGEID=chargestable.CHARGEID
LEFT JOIN AaaUser pct ON chargestable.TechnicianID=pct.USER_ID

      New to ADSelfService Plus?


            • Related Articles

            • Project Time spent

              MSSQL SELECT pr.ProjectID "Project ID", pr.TITLE "Project Title", taskdet.TaskID "TaskID", taskdet.TITLE "Title", tkd.description "Task Description", taskowner.FIRST_NAME "Owner", dateadd(s, datediff(s, GETUTCDATE(), getdate()) + ...
            • Time Spent on each module

              This Report helps us to know the time spent by technicians on each module.  The Time spent report provides a step-by-step record by which time-related data can be traced to their source and provides a complete history of all Technician activities ...
            • Request Problem association.

              This Report is used to find the request, problem association. To make any changes to a query, refer to the KB article below. SELECT wo.WORKORDERID ...
            • Time elapsed analysis

              This Report gives a clear picture of, how long the request was handled by each technician, stayed in each group and stayed in different statuses. Capturing each action performed on the request can be helpful for the request management team to assess ...
            • Problem Notes

              SELECT prob.PROBLEMID "Problem ID", prob.TITLE "Title", ownaaa.FIRST_NAME "Technician", longtodate(prob.REPORTEDTIME) "Reported Date", sdno.description "Notes" FROM Problem prob LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID LEFT JOIN AaaUser ...