/build/static/layout/Breadcrumb_cap_w.png
10/28/2016 658 views
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

Comments

  • Thank you so much for you time and help! I will give it a try.
  • BTW, like the name you used! Hilarious!

All Answers

1
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


Answered 10/31/2016 by: chucksteel
Red Belt

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