How do I create a report of activity starting from a fixed date?
I'm trying to create a Year-to-Date report in KACE which lists all tickets that wre closed within the last year. I know I can do this using the wizard by configuring the "is within last" filter, however this approach will not be cumulative. Each time I run the report it will only pull tickets starting one year ago from that point in time. In other words, I need the option to replace "is within last" with a specific date so that the report is always beginning with the same start date. I'm not great with SQL but If someone can help me with the SQL I can probably figure it out.
Community Chosen Answer
Here's the where clause I used for a similar report on average time to ticket close. You just change the date range to what you want.
and TIME_CLOSED>'2013-02-01' /*change the start date here*/
and TIME_CLOSED<'2013-02-28' /*change the end date here*/
and HD_TICKET.HD_QUEUE_ID in (1) /*add queue numbers here*/