Task Comments and Description

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.


SELECT taskdet.TASKID AS "Task ID",
       taskdet.TITLE AS "Title",
       taskowner.FIRST_NAME AS "Owner",
       taskcreatedby.FIRST_NAME AS "Created By",
       taskstatus.STATUSNAME AS "Task Status",
       taskdesc.DESCRIPTION AS "Description",
       c.comment "Comments" 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 StatusDefinition taskstatus ON taskdet.STATUSID=taskstatus.STATUSID
LEFT JOIN TaskDescription taskdesc ON taskdet.TASKID=taskdesc.TASKID
LEFT JOIN TaskToComment tskc ON tskc.taskid = taskdet.taskid
LEFT JOIN Comments c ON tskc.commentid=c.commentid
WHERE taskdet.CREATEDDATE >= <from_thisweek> and taskdet.CREATEDDATE <= <to_thisweek>


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 ...
          • How to automatically create a task in a Change Request.

            This is a sample script to create a task in a Change Request based on the values given in certain fields. This is done by using an API call to create  a task in ServiceDesk Plus. The task can also be created in a request, problem, project or a ...
          • Onhold comments

            This report helps to find the reason for the request that are placed onhold 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 ...
          • Show request attributes in Task Subject / Description

            Requirement: To show the request field values such as Request Type, Status etc., or the additional field values in the Task subject/description. Usecase: When a task is triggered from a request, it should contain the request details (configured) in ...
          • Closed request with pending task

            This report is used to get all completed request with the pending task.     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 ...