Our ticket handling strategy allows priority to be changed over the lifecycle of a ticket (example: moving a ticket from Critical to High). I would like a report that shows the highest priority setting applied to our tickets (incident and service requests).  Example:

TICKET --- HIGHEST PRIORITY SET --- SUBJECT --- DESCRIPTION --- ETC...

Ticket123 --- Critical --- Broken printer --- Printer1 is not working ---

Ticket23 --- High --- Upgraded monitor request --- I need a bigger monitor ---

Ticket43 --- High --- Computer slow --- My computer does not run fast ---

Ultimately, I need the highest priority setting applied to tickets (Critical, High, Medium, Low) and then dump the information to Excel in order to build various metric reports. (ex. How many critical tickets have we handled?)

It appears the built-in reporting does not search historical information, only current state.

ME: 9.2 Build 9200

The database is SQL

Thank you in advance!

Tim