Recovering lost media

A short while ago, something odd happened on my media server, and I lost a portion of my movie collection (specifically all movies beginning with the letters N-S). Ultimately, I'm attempting to recover a list of all these movies so I can get them again. If I remember my numbers correctly, it's about 500 movies.

 

While working on this project, I've noticed that one of the movies that I lost (all the movies are additionally not showing up on the Plex server) still retained the 'watched' status after I obtained it again, so I figure Plex must have a list of these movies somewhere. 

 

Where could I potentially find this information? If it's nested in files I can likely write a script that would parse everything (forming a master list) and go from there, but the folder structure in Appdata/Media/localhost seems to be rather complex for me to be able to find in any reasonable time.

I tried to comb through the information there, but I wasn't able to find any information tied to media that was no longer in the library.

Is there any other place I may be able to get a comprehensive listing of no-longer-existing media, or am I out of luck?

Reviving an old thread.  I too am trying to audit a disaster.  I have a datestamped copy of the db from several days ago that is loaded in sqlitebrowser.  Can someone please tell me how to query or look for my lost gems?  I am not even exactly sure when the deletes happened.  I just realized that my Movie count seems to be off by about 100 movies or so!?!?!?

Thanks.  :(

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.