-
Copy ‘/home/xbian/.xbmc/userdata/Database/MyVideos75.db’ from the XBMC machine to your local computer.
-
Open with SQLite3:
:~$ sqlite3 MyVideos75.db -
Select rows that have have a play count of more then 1 time:
SELECT strFilename FROM files WHERE playCount > 0;