Photoshop Elements :: Creating A List Of Missing Files In Organizer?

It is a pity the dialog of the 'reconnect missing files' can list the missing files in a small window, but there is no option to export the list with full paths as a text file.

Knowing that the list is saved somewhere (probably in the catalog folder) I have searched if I could find how the information about missing files is stored in the Organizer. Natural candidates like the catalog.psexxdb and thumbs.5.cache sqlite databases did not show anything showing they stored the information.
 
So, I had a look at the thumbs.5.cache, which is interesting. It shows that two sizes of thumbnails are stored there, and that the criteria for matching are date taken and file size.

Now, I compared an optimized version of that file with a reconstructed one (I deleted the cache file).
Interestingly, you can see which media_id still have the matching criteria. I conclude that the other media_id are the missing files...
 
If Photodrawken is looking at this post : Could you check this supposition and see if a sqlite query could extract the list of the missing media?
 
It will be interesting to see if the next PSE version has a better handling of missing files... Seems that LR handles that problem much better.
 
Edit: The 'status' field in the thumbnail_info_table of the thumbs.5.cache database seems to be set at '2' for missing files.