[2] Total # of Tickets Created & All Tickets with Issue and Status for Past N Days
In both reports, replace 7 with the amount of days prior you would like to report on (i.e. for the last month, change it to 30).
Number of tickets created within the past 7 days:
All tickets opened within the past 7 days and their ID, Issue, and Status:
Number of tickets created within the past 7 days:
SELECT COUNT(*) AS '# of Tickets Created' FROM HD_TICKET T
WHERE DATEDIFF(NOW(), CREATED) < 7All tickets opened within the past 7 days and their ID, Issue, and Status:
SELECT T.ID AS 'Ticket #', T.TITLE AS 'Issue', S.NAME AS 'Status' FROM HD_TICKET T
JOIN HD_STATUS S ON (T.HD_STATUS_ID = S.ID)
WHERE DATEDIFF(NOW(), CREATED) < 7
0 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
