How to find post by attachment ID?

[popup]

Hello,
I've got an abuse report with only a link to an abusive attachment file. I searched the attachmentID in admincp but I could not find it.

So wondering how to find the post or user to which the attachment belongs to?
Appreciate your help.

[kh99]

I don't know if there's any way to do it in the admincp, but if you can execute a query you could do:
SELECT userid FROM attachment WHERE attachmentid = ID

where you'd of course replace ID with the actual id.