Reporting on last ticket comment time (4268789)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Reporting on last ticket comment time
Description

The wizard is unable to give specific access to the last ticket comment only last ticket update which can include field updates without comments.
Resolution

The following mysql sample will report tickets with comments added in the last 7 days.
SELECT hd_ticket.id,
hd_ticket.title,
TC.timestamp
FROM hd_ticket_change TC
left join hd_ticket
ON hd_ticket_id = hd_ticket.id
WHERE Cast(TC.timestamp AS DATETIME) > Date_sub(Now(), interval 7 day)
AND description = ''
-----------------------------------------------------------------------NOTICE--------------------------------------------------------------------------------------------
-- CODE WRITTEN BY QUEST KACE SUPPORT FOR DEMONSTRATION PURPOSES ONLY
--USE OF THIS CODE CONFIRMS THE NEED FOR TESTING AND USER ACCEPTS ALL RESPONSIBILITY FOR USE AND MISUSE OF CODE.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title