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. 

          • 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 ...
          • 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 ...
          • Report on Conversation

            This report gives an overview of all Conversation of Technician and requester.  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 ...
          • Script to mark all private notes as public

            Use case: Once a request is resolved all the private notes should be made public (requester shall view). Prerequisites: 1. Python Installation Steps :  https://pitstop.manageengine.com/portal/kb/articles/how-to-setup-python-on-the-server ...