I found a script called RequestTracker-Stats which can quickly analyze RT data and generate statistics. See [https://gist.github.com/948075] for a few examples. We don't need this script on the same host as RT, as long as I can log in and run the script at the end of every month.
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information