Onhold comments

Onhold comments


This report helps to find the reason for the request that are placed onhold



SELECT wo.WORKORDERID "Request ID",
       mdd.MODENAME "Request Mode",
       qd.QUEUENAME "Group",
       aau.FIRST_NAME "Requester",
       cd.CATEGORYNAME "Category",
       ti.FIRST_NAME "Technician",
       std.STATUSNAME "Request Status",
       (os.onholdcomments) "Reason For Stop Timer" FROM WorkOrder wo
LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
LEFT JOIN onholdscheduler os ON wo.workorderid=os.workorderid
WHERE (wo.ISPARENT='1')
 

Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report. 






          • Related Articles

          • Close comments

            This report is used to find the close comment added by requester.  To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000627781192 SELECT wo.WORKORDERID ...
          • Task Comments and Description

            This report is used to find the task comments and Description. 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 taskdet.TASKID AS ...
          • Report on Technician Leaves with date filter

            DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 SELECT cre.FIRST_NAME "Created By", LONGTODATE(TechUnavailability.CREATEDDATE) "Created Date", avail.FIRST_NAME "Technician on Leave", back.FIRST_NAME "Backup Technician", ...
          • Azure DevOps Integration

            Feature:  Azure DevOps Integration <-->  ServiceDeskPlus (Plugin Model) --> Create a new work-item in Azure DevOps when a request is created in SDP --> Update SDP request status when a Azure DevOps work-item status is updated --> Updating Comments ...
          • Close requests with pending approval for more than 10 days

            Requirement:  Close older requests with pending approvals. UseCase:  Close all requests for which approvals have been sent but no action has been taken in more than 10 days. Please follow the below steps.  Goto Reports > New Query Report > execute ...