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 != ''
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 ADSelfService Plus?
Related Articles
Query to list out the notes added to the tickets
QUERY: To list of the notes added to the tickets while generating report report SELECT ti.FIRST_NAME AS "Support Rep", wo.WORKORDERID AS "Request ID", longtodate(wo.CREATEDTIME) AS "Created Time", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Contact", ...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", ...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 ...Send email notification to requester when a note is added to a request
How it works? A report will be scheduled to run at a periodic interval which will fetch he details of the request. Once the schedules runs, the script will fetch the values from the report and sends an notification through email to the requester of ...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) ...