Clear Watch History for Specific User

Plex Media Server
1

I’m trying to clear/reset the “Watch History” for a specific user, I’ve used “Advanced Filters” and set “Plays – is greater than – 0” for Movies and “Show Plays – is greater than – 0” for TV Shows for each Library and set any matching items to “Unwatched”.

I have also tried running the following SQLite commands directly on the database “DELETE FROM metadata_id_views WHERE account_id = ;” and “DELETE FROM statistics_media WHERE account_id = ;” and restarted Plex after the database changes, but I have the User Profile showing “6 Shows and 8 Episodes Watched since joining Plex” showing. Even the Dashboard Play History for “All Time” for the specific user says 0 (actually the user does not even populate in the list of users).

Is there another table I need to run a SQL statement against or does someone have a complete SQL command/statement that will purge the watch history for a specific user correctly? I don’t need to/want to delete the user itself, just reset/clear the watch history for a specific user. Any help would be greatly apricated. Thanks

2

Watch state count from profile is not stored on your server. It is part of their account.

Could be things that were marked as watched on watch.plex.tv or Discover that you never had, or was watched on a different server.

Though we are working on a way to remove it there is not a current way to delete or mark as unwatched that data directly if you don’t know what it is.

3

Thanks for the information, guess that must be the case because even running “DELETE FROM metadata_item_settings WHERE account_id = id;” still shows “6 Show / 8 Episodes” unfortunately I cannot find a way to find out which “6 Shows / 8 Episodes” on Plex is referring to, I can see “plex://show/guid” entries reappearing in “metadata_item_settings” but cannot find the GUID to see which show it are referring to.

Hopefully the ability to see what was watched and marking them as unwatched for “plex Movies/TV Shows” is coming soon.

Thanks again for the response.

4

You can find what the guid item is in metadata_items. Field title

With DB Browser for SQLite you can browse the tables in the db. But do it preferably on a copy of the db.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.