KACE Product Support Question
how to pull a report on tickets 'created by ' ?
10/12/2016 984 views
what sql detail collects this data, how do I create a report to get the CREATED BY info
Answer Chosen by the Author
Please log in to answer
You get the CREATED BY info from the HD_TICKET_CHANGE table, just filter on the description field as below. This should get you started.
COUNT(HD_TICKET_CHANGE.HD_TICKET_ID) AS count
USER ON USER.ID = HD_TICKET_CHANGE.USER_ID
description LIKE 'Ticket Created%'
AND timestamp > DATE_SUB(NOW(), INTERVAL 7 DAY)
GROUP BY USER.USER_NAME
ORDER BY USER.USER_NAME
Answered 10/12/2016 by: grayematter