Yes, the GM Knowledge Base is stored in the INFOMINE table.
The attachment information is stored in the LINKEDDOC field, formatted a certain way.
See if this helps:
select * from INFOMINE where linkeddoc like '%~~FILENAME=%'
I find the simplest thing to do is use universal search, check the advanced box, uncheck ALL and check just the knowledge base:
I didn't even know Universal Search existed. It sure is well hidden and interesting to play with. I couldn't find a direct way to use it for this task, the SQL query worked fine. Thanks for pointing this out.
generally, I just issue the search in question via the Universal search box on screen at all times in the upper-left corner of my GoldMine. From there, if my result isn't already near/at the top of the list, I'll hit the advanced/all/kbase checkbox to whittle it down. It's a pretty quick and effective workflow for me, typically.