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:
New to ADSelfService Plus?
Related Articles
Automatically Add a Note and Mark First Response When a Ticket Is Moved to Assigned State
Requirement: This automation ensures that when a ticket transitions to the Assigned state, a note is automatically added to the ticket and the first response is marked. This helps maintain consistency in ticket updates and response tracking without ...
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. ...
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 to show roles assigned to a technician with created date, status and department name (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Query: select auser.first_name as "TECHNICIAN", max(sd.employeeid) as "Employee ID", longtodate(auser.createdtime) as "Creation Date", STRING_AGG (arole.name, ',') "Current Assigned Role", ...
Query to get the Request First Assigned time
Use case: First Assigned Time is the number of minutes, hours, or days between when a requester submits a request and when was a support representative assigned to the Request. It indicates how long it is in an unassigned state. Working on Build: ...