KACE Product Support Question
Hello, Im looking to create a custom ticket view for weekdays only between 5pm and 12am for the last 3 months. How can I do this? I cant quite seem to figure it out.
Answer Chosen by the Author
Using a custom ticket view for this type of search might not be the best approach and actually isn't possible because of the options available. A report would be a better approach. The reporting wizard should be able to create this report, but if not, here is a SQL query that will return tickets created after 5:00pm on week days for the past three months.
SELECT ID, TITLE, CREATED
WHERE HOUR(CREATED) >= 17
AND DAYOFWEEK(CREATED) BETWEEN 1 and 7
AND CREATED > DATE_SUB(NOW(), INTERVAL 3 MONTH)