2024-03-28, 02:53 PM
When I travel I carry a SSD with media I have not yet played with me to be entertained during transportation. The media files are synced using rsync from my NAS. For rsync I need a list of unplayed media filenames. In earlier days I generated this list from the Kodi library using SQL. Nowadays I am using Jellyfin for Kodi, i.e. I could still use the Kodi library DB to extract that list. However, this seems to be a somewhat indirect approach, as this data gets synced from Jellyfin anyways.
So I would rather like to extract the list of unplayed movies/tvshows from Jellyfin using the UI, or if that is not possible, using SQL from the Jellyfin library DB.
Clearly I can generate a list of unplayed movie titles in the UI, but I have not found a way to export the list of these movie titles to a text file. So my first questions are whether this can be done and how. Also: The Titles as shown in the UI do not necessarily match the filenames on disk, so this approach is probably doomed anyway.
If it is not possible to extract a list of unplayed movie filenames from the UI, where would I find some example SQL queries (or possible queries that would already do exactly what I have described)?
Where may I find documentation about the table attributes of the Jellyfin library DB?
So I would rather like to extract the list of unplayed movies/tvshows from Jellyfin using the UI, or if that is not possible, using SQL from the Jellyfin library DB.
Clearly I can generate a list of unplayed movie titles in the UI, but I have not found a way to export the list of these movie titles to a text file. So my first questions are whether this can be done and how. Also: The Titles as shown in the UI do not necessarily match the filenames on disk, so this approach is probably doomed anyway.
If it is not possible to extract a list of unplayed movie filenames from the UI, where would I find some example SQL queries (or possible queries that would already do exactly what I have described)?
Where may I find documentation about the table attributes of the Jellyfin library DB?