We have K1000 v6.4, Is possible to create a report the tracks when a specific user comments on tickets
Is possible to create a report the tracks when a specific user comments on tickets where that user is not the owner of the ticket? I have a person that spends more time commenting unhelpfully than actually handling and solving tickets. Help would be most appreciated.
2 Comments
[ + ] Show comments
-
Thank you so much for you time and help! I will give it a try. - mad48 8 years ago
-
BTW, like the name you used! Hilarious! - mad48 8 years ago
Answers (1)
Please log in to answer
Posted by:
chucksteel
8 years ago
This will show you all of the tickets where the specified user commented on a ticket that they are not the owner. It will also give you a count of the number of comments made.
SELECT T.ID as "Ticket ID", COUNT(C.ID) as "# of Comments", OWNER.USER_NAME as "Owner", COMMENTER.USER_NAME as "Commenter"
FROM HD_TICKET T
JOIN HD_TICKET_CHANGE C ON C.HD_TICKET_ID = T.ID
JOIN USER OWNER on OWNER.ID = T.OWNER_ID
JOIN USER COMMENTER on COMMENTER.ID = C.USER_ID
WHERE OWNER.USER_NAME != 'nosy'
and COMMENTER.USER_NAME = 'nosy'
GROUP BY T.ID
