how to backdate an exisitng Kace report
I have a report based on service desk that I need to run as if it was 1/2/2015. Is this even possible?
Answer Chosen by the Author
To find tickets that were opened on a specific date you want to look for tickets that were created before or on that date, (DATE(CREATED) <= "2015-01-02") and closed after or on that date (DATE(TIME_CLOSED) >= "2015-01-02").
This basic query returns tickets that were open on 2015-01-02:
SELECT ID, TITLE, MODIFIED, CREATED, TIME_CLOSED FROM HD_TICKET
WHERE DATE(CREATED) <= "2015-01-02"
AND DATE(TIME_CLOSED) >= "2015-01-02"
Answered 05/18/2015 by: chucksteel
Please log in to comment
log in to commentPlease