Is there a way to grab a nice list of all my media?

I’m unsure but I think sqlite3 is installed by default, else you have to install it.

Run this commands and you get a list(only valid in kodi 18.x):

sqlite3 ./.kodi/userdata/Database/MyVideos116.db "select c00, c14, c16 from movie_view where 1;" > movielist.txt

This will give you a list, with LocalMovieName, Genre, OriginalTitle

If you want to decode the c00 or other magic in you libary here is a referens page:
KodiDB and here is for the movie_view

PS. The “WHERE 1” is not needed, just added it to show you can put a where-conditions to filter the output. As “WHERE 1” is true for all the lines in the movie_view, you get em all. But you could "WHERE c14 LIKE ‘war’. You would only get a list where genre contains war.

3 Likes