RT's query builder is the main tool for searching and reporting on all of the ticket activity in RT. Here's a basic introduction to creating searches with the query builder and customizing the search results.