Problem and linked requests

Database : MYSQL/MSSSQL/PGSQL

 

Use the below query under Report tab–> New Query Report

 

SELECT prob.PROBLEMID “Problem ID”,orgaaa.FIRST_NAME “Reported by”,ownaaa.FIRST_NAME “Technician”,prob.TITLE “Title”,probdesc.FULL_DESCRIPTION “Description”,longtodate(prob.REPORTEDTIME) “Reported Date”,longtodate(prob.CLOSEDTIME) “Closed Date”,wo.WORKORDERID “Request ID”,wo.TITLE “Subject”,wotodesc.FULLDESCRIPTION “Description”,aau.FIRST_NAME “Requester”,ti.FIRST_NAME “Technician”,std.STATUSNAME “Request Status” FROM Problem prob LEFT JOIN SDUser orgsd ON prob.ORIGINATORID=orgsd.USERID LEFT JOIN AaaUser orgaaa ON orgsd.USERID=orgaaa.USER_ID LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID LEFT JOIN ProblemToDescription probdesc ON prob.PROBLEMID=probdesc.PROBLEMID LEFT JOIN problemtoincidentmapping ptim on ptim.problemid=prob.problemid left join WorkOrder wo on wo.workorderid=ptim.workorderid LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID

This entry was posted in Problem.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500