Email Center - how can I find the SR's that relate to resolved emails in an Email Center Resolved qu

A number of emails have gone to the resolved queue of an email center mailbox, that is set up to automatically create SR's, without creating those SR's.  I'd like to find a way of finding out which emails are associated to which SR numbers and ultimately which emails have been resolved without SR's being raised.  I don't believe there is any manual intervention going on by the user's as they don't generally log into the email center queue as they are expecting the SR's to be raised.
Thanks for any help/advice - is there a SQL query I could run?? Otherwise I'm stuck with trawling through and check all the messages manually.