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