Problem time spent

Problem time spent





SELECT prob.PROBLEMID "Problem ID",
       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 SDUser ownsd ON prob.OWNERID=ownsd.USERID
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

          • 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. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 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 ...