Reading from library (or other) .db

[Scott D 69]

Is there a place within the .db files that would list all of the individual media files associated with all libraries?

Just experienced a hard drive failure and will be reconstructing files (all media) but would like a guide to help remember what has been lost.

Hard drive failed while Emby was not running, so .db files have not been overwritten by a scan.  Copy of all "programdata" files are available.

[Carlo 4561]

Hi, hope this info helps you.

library.db
MediaItems table

If you just want the name of the movie and year you could use this SQL statement

select Name, ProductionYear from MediaItems where type=5 Order by Name, ProductionYear

You can of course add other columns or where statement if needed.  You can do similar for TV Shows if needed.

[Scott D 69]

Excellent.  Thank you so much for the info.  I am heading in the right direction now.