We are just settling in with our K1000 and would like to see how a report like this would look. Appreciate any help, thanks.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
Here is a query that returns the count of tickets created for the past 30 days by the submitter's user label(s):
select L.NAME AS 'User Label',
       COUNT(*) AS 'Tickets created past 30 days'
from   HD_TICKET  T
       join `USER` U on T.SUBMITTER_ID = U.ID
       join USER_LABEL_JT UL on UL.USER_ID = U.ID
       join LABEL L on L.ID = UL.LABEL_ID
where T.CREATED > NOW() - INTERVAL 30 DAY
group by L.NAME

In my environment users can have multiple labels, so totaling the right column would give me an inflated number instead of the actual total number of tickets created during the specified interval.

Answered 09/01/2016 by: JasonEgg
Third Degree Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share