# Clear Watch History for Specific User

**URL:** <https://forums.plex.tv/t/clear-watch-history-for-specific-user/862642>\
**Category:** Plex Media Server\
**Tags:** server-docker\
**Created:** [December 12, 2023, 3:20pm UTC](https://forums.plex.tv/t/clear-watch-history-for-specific-user/862642 "2023-12-12T15:20:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![OzTechGeek](https://avatars.discourse-cdn.com/v4/letter/o/f0a364/32.png) [@OzTechGeek](https://forums.plex.tv/u/OzTechGeek)\
**Post date:** [December 12, 2023, 3:20pm UTC](https://forums.plex.tv/t/clear-watch-history-for-specific-user/862642/1 "2023-12-12T15:20:30Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![BigWheel](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/bigwheel/32/78783_2.png) [@BigWheel](https://forums.plex.tv/u/BigWheel)\
**Post date:** [December 12, 2023, 9:00pm UTC](https://forums.plex.tv/t/clear-watch-history-for-specific-user/862642/2 "2023-12-12T21:00:45Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![OzTechGeek](https://avatars.discourse-cdn.com/v4/letter/o/f0a364/32.png) [@OzTechGeek](https://forums.plex.tv/u/OzTechGeek)\
**Post date:** [December 13, 2023, 1:26pm UTC](https://forums.plex.tv/t/clear-watch-history-for-specific-user/862642/3 "2023-12-13T13:26:36Z")

</div>

> [@BigWheel](#):
>
> watch.plex.tv

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.

---

<div class="post-metadata">

**Author:** ![Yaracuy](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/yaracuy/32/313162_2.png) [@Yaracuy](https://forums.plex.tv/u/Yaracuy)\
**Post date:** [December 13, 2023, 1:38pm UTC](https://forums.plex.tv/t/clear-watch-history-for-specific-user/862642/4 "2023-12-13T13:38:26Z")

</div>

> [@OzTechGeek](#):
>
> 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.

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

With [DB Browser for SQLite](https://sqlitebrowser.org/dl/) you can browse the tables in the db. But do it preferably on a copy of the db.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [March 12, 2024, 1:39pm UTC](https://forums.plex.tv/t/clear-watch-history-for-specific-user/862642/5 "2024-03-12T13:39:08Z")

</div>

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