epmdocument + secondary content (pvs) sql

This will get you the all the derived images an EPMDocument. If you want to see only the .pvs, you can uncomment the last line.

select a.*

  from derivedimage i, epmdocument e, holdertocontent c, applicationdata a, epmdocumentmaster m

where m.cadname = '<name here>'

and m.ida2a2 = e.ida3masterreference

   and i.ida3a6 = e.ida2a2

   and c.ida3a5 = i.ida2a2

   and c.ida3b5 = a.ida2a2

   --and a.role = 'PRODUCT_VIEW_ED';