So, one of my hard drives went bad. It only had TV Shows on it, but I don’t know how to find out what specific content was on that drive. I did download a full database, and I have a SQL Lite viewer, but I don’t know where or how to find the specific content which was on that hard drive. Any help would be GREATLY appreciated.
You could check out ExportTools NG from WebTools-NG. Might be easier 
The server updated the libraries from the missing content, so it’s not on there anymore. I don’t think Export Tools will help in this scenario. All I have is a 522mb db file I took before they thing updated. What’s your thoughts Sir?
I don’t have a full query at hand.
Basically you can lookup the folders from that drive in section_locations – e.g. SELECT id FROM section_locations WHERE root_path="{PATH_PREFIX}*"; (where {PATH_PREFIX} could be the related drive letter or mounting point).
You can then filter media_items by those section_location_ids and use the hints field to identify the missing items. If that’s too vague you can use the id of those media items to lookup the related records from metadata_items.
1 Like
You are a Gentleman and a Scholar. Thank you so much!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
