/build/static/layout/Breadcrumb_cap_w.png

Custom Report - Any Changes by specific tech

When techs update kace tickets, either notes, status, etc...  kace sends an email to the submitter that there is a status change.  SO i know it's keeping track of such data.

I am looking for a report that would tell me What changes a specific tech has made to any tickets at all.  I would need to be able to select a date range as well, else it will look all the way back the beginning of Kace time, but for now, i could live with changes within the last 2 months if that helps.


Any help would be truly appreciated


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 years ago
Red Belt
0

All this info can be found in the Ticket Change (HD_TICKET.CHANGE I think....) table of the database, whenever a ticket is updated it writes it to this table, joining on ticket number from HD_TICKET and assigning an ordinal so you can work out the order.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ