How to run report on what's been watched?

Plex Media Server
1

Server Version#: 1.43.1.10611
Player Version#:

I want to thin out my media. Running low on disk space, but I don’t want to delete content that people are watching (family). Is there a way to run a report that well show me what is being watched, and what has never been watched? I image I have content that no one has watched, and most likely will never watch, but I would like to confirm that before removing it.

Thanks

2

There’s some information on the Plex Dashboard that should list what users have been watching over a certain period (most watched, history…).
https://support.plex.tv/articles/200871837-status-and-dashboard/

3

Thank you, that helps. I just wish I could download this list to a cvs file.
I appreciate the help.

4

All watched data is stored within the metadata_item_views table of your local plex db. You could do an export of this data using something like this …

"/usr/lib/plexmediaserver/Plex Media Server" --sqlite com.plexapp.plugins.library.db ".output watched-data.sql" ".dump metadata_item_views"

… and then import it into a spreadsheet. Might not give you all you want but might give you a bit …

Alternatively, you could probably query the plex server using the api to list shows/movies which have never been watched. Something like this https://www.plexopedia.com/plex-media-server/api/library/movies-unwatched might be a good place to start.

5

Thank you for the info. The sql command didn’t return anything for me, but I think the API is really what I’m looking for. I’ll have to take some time to read over the documentation and figure out how to use it.

Thanks

6

Actually, that wasn’t to difficult to figure out. Now I just need to find an XML view and I think I’ll be set.

Thanks for the info.

7

WebTools-NG will let you export data from the database into a csv file.

8

I’ll give this a try. The two previous suggestions didn’t really give me the data I was hoping to get.

Thanks. I appreciate the suggestions.