/build/static/layout/Breadcrumb_cap_w.png

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:
Posted by: grayematter 10 years ago
5th Degree Black Belt
4

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')


Comments:
  • Awesome! Thank you Gray. Worked well. - gambitz 10 years ago
    • Gambitz, don't forget to press the Up Arrow next to his answer to rate it up :) - colbya 10 years ago

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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ