Our great sponsors
-
sqlitebrowser
Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
If you have a Plex Pass the Play History dashboard will show you everything that's been played, and can be filtered to individual libraries/users. I'm not aware of any way to scope it down to a specific show if it doesn't currently exist in your library though. Tautulli could help with this as well, and doesn't require a Plex Pass. Worst case you can query the database directly if you're comfortable with that, since I believe Plex still tracks it all even if you don't have a Plex Pass, the UI just isn't available.
As far as looking at the database, it's located at 'Plug-in Support/Databases/comp.plexapp.plugins.library.db' within your data directory. While you need Plex's own Plex SQLite to write to some tables, if you're just combing through data it may be easier to use something like DB Browser. From there, watch history is stored in the metadata_item_views table. If you want a list of everything that's been played, but is no longer in Plex, the following query might do it (it's been very minimally tested, but I wouldn't be surprised if there are some things I missed: