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