I need help writing a SQL report to show all tickets INCLUDING any tickets in the archive.
I'm looking for an executive report that shows all tickets that have been opened in the past 12 months. Currently I have archiving set up for tickets that have been closed over 6 months. I can only seem to report on EITHER the archive OR my service desk, but not a report that will give me a true ticket report from BOTH.
There are no answers at this time