There are other people much more knowledgeable about source links than I am, but while waiting for them to respond, I will add my bit.
If you export the entire database as a gedcom file, you can open the gedcom in a text editor or word processor. You can then use its search function to search for all occurrences of FILE, as follows.
1 BIRT 2 DATE 6 Feb 1953 2 PLAC Canmore, Alberta, Canada 2 SOUR @S13@ 3 OBJE 4 FORM JPG 4 FILE for-PAFGriffin Henry 1953 -birth.JPG
In the example above, the file "Griffin Henry 1953 -birth.JPG" is linked as a source image for the birth of Henry Griffin. It is found in the for-PAF folder in the same location as the PAF data file that uses it.
A non-source image link looks like this: 1 OBJE 2 FORM jpg 2 FILE for-PAFGriffin_Henry_Robert1.jpg
Both the above links are Relative links, i.e. the location of the image is given relative to the location of the data file. An Absolute link has the complete file path for each linked image, starting with a drive letter like this: 2 FILE c:PAF_Datafor-PAFGriffin_Henry_Robert1.jpg
This information might be sufficient to allow you to quickly view the media links in your file. If the linked images are COPIED(not moved) to a single folder (like my for-PAF folder) located in the same location as the PAF data file, you may be able to automatically relink them as Relative links in PAF by clicking the camera icon, then Modify, Browse. And ask PAF to use that location for all of the linked photos. I haven't tried it with source images but it works great for regular images and other linked media objects.
CAUTION Do this on a COPY of the PAF database, not the original. If you leave the original PAF data file untouched and do not MOVE the images, then your experiment will not change the current status. When the COPY is working as you want, then it becomes your main copy of the database and the original can be archived.
On your other question, custom reports can be created to view the data in the form of a table. This also allows you to create tab delimited files that can be opened in a spreadheet. It may not be exactly what you are looking for, but may come close enough.