Report on Notes

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.


For builds lower than 11139


SELECT wo.WORKORDERID "Request ID", note.NOTESTEXT "Notes", longtodate(notesdate) "Note Added date", aaauser.first_name "Note Added By" FROM WorkOrder wo
LEFT JOIN Notes note ON wo.WORKORDERID=note.WORKORDERID
LEFT JOIN AaaUser aaauser  ON note.userid=aaauser.user_id
WHERE wo.CREATEDTIME >= <from_thisweek> AND wo.CREATEDTIME <= <to_thisweek>

For build 11139 and higher


SELECT wo.WORKORDERID "Request ID", note.NOTESTEXT "Notes", longtodate(note.CREATEDTIME) "Note Added date", aau.first_name "Note Added By" FROM WorkOrder wo
LEFT JOIN WorkOrderNotes wnotes ON wnotes.WORKORDERID=wo.WORKORDERID
LEFT JOIN Notes note ON wnotes.NOTESID=note.NOTESID
LEFT JOIN AaaUser aau ON note.CREATEDBY =aau.USER_ID
WHERE wo.CREATEDTIME >= <from_thisweek> AND wo.CREATEDTIME <= <to_thisweek> AND note.NOTESTEXT != ''

Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report. 
        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?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • Related Articles

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

                      • Query report to show Problem fields along with last added notes (MSSQL & PGSQL)

                        Tested in build PGSQL (14300) and MSSQL (14306) PGSQL & MSSQL: SELECT prob.PROBLEMID AS "Problem ID", LONGTODATE(prob.REPORTEDTIME) AS "Reported Date", orgaaa.FIRST_NAME AS "Reported by", LONGTODATE(prob.DUEBYTIME) AS "DueBy Date", ...

                      • Script for hiding an option "Show this note to Requester" while adding Notes - For Technician Login

                        Compatible for 10500 Build * Stop Servicedeskplus-msp application service. * Navigate to [SDP_MSP-Home] > custom > scripts take a backup of existing CustomScripts.js file. * Use the attached CustomScripts.js file and replace it under [SDP_MSP-Home] > ...

                      • Software Compliance Report

                        Number of products out of compliance select swct.compliancetype "Compliance Type",count(swcd.softwareid) "Number of Products" from SWComplianceDetails swcd left join swcompliancetype swct on swcd.swcompliancetypeid=swct.swcompliancetypeid where ...

                      • Query to show last notes added in request (MSSQL & PGSQL)

                        Tested in Build PGSQL (14300) or MSSQL (14306) select wo.workorderid "request id", max(wo.title) "subject", max(qd.queuename) "group", max(std.statusname) "request status", max(pd.priorityname) "priority", max(sdo.name) "site", max(wo.createdtime) ...

                        Related Products