Query Report to show who applied a Cat / SubCat / Item
I'm sure this is quite simple to carry out, but I need a query report that documents Category / SubCat / Item changes to tickets, and the name of the technician that applied each change.
Fields to show
Request ID
Requester
Request Type
Subject
Request Status
Created Time
Completed Time
Site
Region
Category changed to
Subcategory changed to
Item changed to
Technician that changed it
Time change was made
Some tickets will have their categories changed multiple times, so the report should ideally show all changes to a ticket (ideally as separate entries)
Database: MSSQL
Version and Build: 9.2 Build 9221