05 Jan 2014, 00:00

XBMC: Get List of Watched Files/Videos From Command Line
  1. Copy ‘/home/xbian/.xbmc/userdata/Database/MyVideos75.db’ from the XBMC machine to your local computer.
  2. Open with SQLite3:

    :~$ sqlite3 MyVideos75.db
    
  3. Select rows that have have a play count of more then 1 time:

    SELECT strFilename FROM files WHERE playCount > 0;