+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Support (https://forum.jellyfin.org/f-support)
+--- Forum: General Questions (https://forum.jellyfin.org/f-general-questions)
+--- Thread: Unwatched Across All Users (/t-unwatched-across-all-users)
Unwatched Across All Users - halexh - 2024-09-10
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.
RE: Unwatched Across All Users - TheDreadPirate - 2024-09-10
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/blob/987dbe98c8ab55c5c8eb563820e54453c835cdde/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs#L19