/build/static/layout/Breadcrumb_cap_w.png

Looking for reporting on helpdesk to show each time status was changed and how long it stayed at that status.

Here is how the request came to me:

I need a new KACE report for the following:

Lable the report history of a ticket

Date ticket was submitted

Date ticket Owner was changed from Default Ticket Owner to "a person" including BTS. Sort by ticket number

Date ticket status was changed from new to "any status" and if status was changed I need each time status was changed.

I need each status change noted on report, and a calculated days for processing

This report needs to multiple request features:

BY ticket nmber
BY Assignee
BY date range

and a all inclusive

 


3 Comments   [ + ] Show comments
  • This should get you started.
    SELECT
    *
    FROM
    ORG1.HD_TICKET_CHANGE_FIELD
    LEFT join
    ORG1.HD_TICKET_CHANGE ON HD_TICKET_CHANGE.ID = HD_TICKET_CHANGE_FIELD.HD_TICKET_CHANGE_ID
    LEFT join
    ORG1.HD_TICKET ON ORG1.HD_TICKET_CHANGE.HD_TICKET_ID = ORG1.HD_TICKET.ID
    where
    FIELD_CHANGED = 'STATUS_NAME'; - grayematter 9 years ago
  • Thank you, can you also get me started on how to report on ticket owner being changed from default ticket owner to anything?

    Is there a data dictionary somewhere for all these fields? - nadecats 9 years ago
  • For ticket owner, you would be keying on HD_TICKET_CHANGE_FIELD.FIELD_CHANGED with a value of either OWNER_ID or OWNER_NAME. The tables are listed in the Administrator Guide but not the fields.

    You can use any ODBC browser/query editor (such as MySQL Workbench to view the fields and work on queries. Directions on setting up the connection are at http://www.kace.com/support/resources/kb/solutiondetail?sol=114992 - grayematter 9 years ago

Answers (0)

Be the first to answer this question

Don't be a Stranger!

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

Sign up! or login

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