Requests updated by technician query
I need a Mysql query report that will give me the last time the request was last updated by a technician in ServiceDesk for all pending issues (open, onhold, resolved). It should include the following: Request ID, Technician, request status, Subject line of the request, the Most current discussion note, Date / time of the most current discussion note, and No. of days since the request was last updated.
By request updated, I am referring to a requester conversation email was sent, a discussion note was added to the request, or work log time added.
By request updated, I am referring to a requester conversation email was sent, a discussion note was added to the request, or work log time added.