Custom Kace report for a specific month
Hello,
How do I modify the following canned report to not report on the last 31 days but the Month of April 2014?
select ifnull((select CUSTOM_2 from USER where HD_TICKET.SUBMITTER_ID = USER.ID),' External') as SUBMITTER_DEPT,
count(HD_TICKET.ID) AS Total_Requests
from HD_TICKET
left join HD_STATUS on HD_STATUS_ID = HD_STATUS.ID
where HD_STATUS.STATE = 'closed' and HD_TICKET.TIME_CLOSED > DATE_SUB(NOW(), INTERVAL 31 DAY)
group by SUBMITTER_DEPT
order by SUBMITTER_DEPT
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
grayematter
10 years ago
replace
HD_TICKET.TIME_CLOSED > DATE_SUB(NOW(), INTERVAL 31 DAY)
with
HD_TICKET.TIME_CLOSED > date('2014-04-01') and HD_TICKET.TIME_CLOSED < date('2014-05-01')
