GoDawgs,

Here is a query to find out which test cases had attachments:

SELECT * FROM SMART_REPOSITORY_LOGICAL_FILE
WHERE SRLF_PARENT_PATH = '.attach' AND
SRLF_NAME LIKE '%TEST%' OR
SRLF_NAME LIKE '%STEP%'

This will give you all attachments. If you only want attachments to Tests, take off the final OR clause but this would remove any attachments to Test Steps.
Unfortunately, this query is on the Smart Repository Logical File and not the Physical File so you may need help from your DBA to get to your physical files. I do think that the test IDs are listed in the resulting SRLF_NAME field as TEST_*_FileName.