Problem details with root cause,workaround and solution

Problem details with root cause,workaround and solution



SELECT prob.PROBLEMID "Problem ID",
       prob.TITLE "Title",
       probdesc.FULL_DESCRIPTION "Description",
       catadef.CATEGORYNAME "Category",
       subcatadef.NAME "Subcategory",
       itemdef.NAME "Item",
       orgaaa.FIRST_NAME "Reported by",
       ownaaa.FIRST_NAME "Technician",
       rc.rootcause "Root Cause",
       impactdef.NAME "Impact",
       solwork.DESCRIPTION "Workaround",
       solres.DESCRIPTION "Solution",
       longtodate(prob.REPORTEDTIME) "Reported Date",
       longtodate(prob.CLOSEDTIME) "Closed Date",
       statdef.STATUSNAME "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 CategoryDefinition catadef ON prob.CATEGORYID=catadef.CATEGORYID
LEFT JOIN SubCategoryDefinition subcatadef ON prob.SUBCATEGORYID=subcatadef.SUBCATEGORYID
LEFT JOIN ItemDefinition itemdef ON prob.ITEMID=itemdef.ITEMID
LEFT JOIN ProblemResolution probResol ON prob.PROBLEMID=probResol.PROBLEMID
LEFT JOIN ImpactDefinition impactdef ON probResol.IMPACTID=impactdef.IMPACTID
LEFT JOIN ProblemToDescription probdesc ON prob.PROBLEMID=probdesc.PROBLEMID
LEFT JOIN SolutionToWorkAround probwork ON prob.PROBLEMID=probwork.PROBLEMID
LEFT JOIN Solution solwork ON probwork.SOLUTIONID=solwork.SOLUTIONID
LEFT JOIN SolutionToResolution probres ON prob.PROBLEMID=probres.PROBLEMID
LEFT JOIN Solution solres ON probres.SOLUTIONID=solres.SOLUTIONID
LEFT JOIN problemresolution ps ON ps. PROBLEMID=prob.problemid
LEFT JOIN StatusDefinition statdef ON prob.STATUSID=statdef.STATUSID
LEFT JOIN RootCause rc on rc.problemid=prob.problemid


                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • Problem and Associated incidents with Request id

                      MSSQL SELECT "prob"."PROBLEMID" AS "Problem ID", max("prob"."TITLE") AS "Title", longtodate(max("prob"."REPORTEDTIME")) AS "Reported Date", max("prob"."DUEBYTIME") AS "DueBy Date", max("orgaaa"."FIRST_NAME") AS "Reported by", max("probf"."UDF_CHAR1") ...
                    • How to proactively handle problem management in your IT environment.

                      This post describes the use of a python script to analyze the nature of the requests and alarms the technicians about frequently raised requests' category, and sub-category. This may help the technicians to proactively start their investigation in ...
                    • Old Solution Link update

                      After migrating 14200 build our old solution link format is not accessible, in this situation one of our customer referred more number of old solution links in some solutions description, in this scenario we need to update the old format link to new ...
                    • Problem Notes

                      SELECT prob.PROBLEMID "Problem ID", prob.TITLE "Title", ownaaa.FIRST_NAME "Technician", longtodate(prob.REPORTEDTIME) "Reported Date", sdno.description "Notes" FROM Problem prob LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID LEFT JOIN AaaUser ...
                    • Requester details

                      This report is used to find the Requester complete details.  SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...