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. 







      New to ADSelfService Plus?

      Start your free trial

        Resources

            • 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 ...

            • Update Task description with Request description.

              Requirement: Copy the request description content to all the associated task description. Usecase: When a task is triggered from a request, it should contain the request description in the description of the task. This will enable task technician to ...

            • 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 ...