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 ADManager Plus?

          New to ADSelfService Plus?

            • 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 ...
            • 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 ...
            • Unauthorized Access CSV Report for Users Not Present in the Application

              Report Details: Currently, the application has not been recording data regarding login attempts when the username used is not available in the application. This report will store the login attempts with usernames who do not exist in the application. ...
            • Report on Organizational roles

              DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 select  r.orgrolename "orgrolename", r.description "Description", au.FIRST_NAME "Name", DepartmentDefinition.DEPTNAME "Department", SDOrganization.NAME "Site"  from aaauser au ...
            • Add notes when a technician is assigned

              Requirement: Automatically add note in the ticket and consider it as a first response when a ticket is initially assigned to a technician. Steps to configure: Goto Admin > Developer Space > Request Custom Functions > Global function > New > Paste the ...