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;