Hi team,

I want have a report with this query but for Problems, Changes and Projects.

SELECT wotask.TITLE "Request Title",wotask.WORKORDERID "RequestID",(taskdet.TASKID) "Task ID",(taskdet.TITLE )"Title",

(taskcreatedby.FIRST_NAME) "Created By",

(taskowner.FIRST_NAME) "Owner",(taskdet.PER_OF_COMPLETION) "Percentage Of Completion",

longtodate(taskdet.CREATEDDATE) "Created Date", wotask.TITLE "Request Title",

longtodate(taskdet.SCHEDULEDSTARTTIME) "Scheduled Start Time",

longtodate(taskdet.SCHEDULEDENDTIME) "Scheduled End Time",longtodate(taskdet.ACTUALSTARTTIME) "Actual Start Time",longtodate(taskdet.ACTUALENDTIME) "Actual End Time",taskprior.PRIORITYNAME "Priority",taskstatus.STATUSNAME "Task Status", tkc.COMMENT "Task Comments" FROM WorkOrder wotask

LEFT JOIN WorkOrderToTaskDetails wototaskdet ON wototaskdet.WORKORDERID=wotask.WORKORDERID

LEFT JOIN  TaskDetails taskdet ON taskdet.TASKID=wototaskdet.TASKID

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 PriorityDefinition taskprior ON taskdet.PRIORITYID=taskprior.PRIORITYID

LEFT JOIN StatusDefinition taskstatus ON taskdet.STATUSID=taskstatus.STATUSID 

LEFT JOIN TaskComments tkc ON taskdet.TASKID=tkc.TASKID 

WHERE  taskdet.CREATEDDATE>= <from_thismonth> AND taskdet.CREATEDDATE<= <to_thismonth>

  ORDER BY 2 ,11

Looking forward to hearing from you soon.