I would consider myself a SQL query hacker. Trying to come up with a query that shows a list of edrawing markup files (serialized file naming with MRK- as the prefix) in a vault and the original solidworks file I linked to it via a Paste as Reference. Here is what I have so far:

select Documents.Filename as 'Markup File', XRefs.XRefDocument as 'Original Document'

from Documents

join XRefs on Documents.DocumentID=XRefs.DocumentID

where Filename like 'MRK-%' and Deleted=0

My results show:

  I would like to see the file name instead of document id in the second column. Any thoughts on how to do that?