Problem Notes

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 ownaaa ON ownsd.USERID=ownaaa.USER_ID
LEFT JOIN problemtonotes prono ON prob.PROBLEMID=prono.PROBLEMID
LEFT JOIN problemnotes sdno ON prono.NOTESID=sdno.NOTESID
ORDER BY 1
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • Related Articles

                      • Report on Notes

                        This report gives an overview of all Notes added by the Technician. This report helps to find a specific word in the Notes, specific technician name etc..  To make any changes to a query, refer to the KB article below. ...

                      • Request Problem association.

                        This Report is used to find the request, problem association. 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 wo.WORKORDERID ...

                      • Auto-create problem request based on certain criteria.

                        This is a sample script that triggers the creation of a Problem Request in ServiceDesk Plus using the Problem API.  Use Case:  ​ All incident requests with Priority = High will create a problem ticket with the request's default field values. ...

                      • Problem time spent

                        SELECT prob.PROBLEMID "Problem ID", prob.TITLE "Title", catadef.CATEGORYNAME "Category", LONGTODATE(prob.REPORTEDTIME) "Reported Date", ownaaa.FIRST_NAME "Technician", priodef.PRIORITYNAME "Priority", statdef.STATUSNAME "Status", ...

                      • 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") ...

                        Related Products