Unwatched Across All Users

[halexh]

I am approaching a state where my 3 14 TB hard drives are about to be full, and I need to start pruning content.

Is there a way to determine what content has not been watched by any user, ever?

The playback reporting plugin has the option to do a custom SQL query, which might give me what I want, but I cannot get a list of all the tables available to query.

[TheDreadPirate]

I don't think the Playback Reporting plugin would meet your need, since I think it only tracks affirmative activity. I don't think it keeps any data about any other content that hasn't been watched.

You'd have to come up with a query for the library.db. I believe this part of the jellyfin code defines the tables you'd be querying against.

https://github.com/jellyfin/jellyfin/blo...ory.cs#L19