Delete all my notes and ratings on my local plex instance

Server Version#:1.42.2.10156

I’m looking for a way to delete all my ratings and votes on my local Plex instance.

Is there a way to go directly to the database? If anyone has a script or command, that would be really, really, really great.

Thanks a lot

If you are talking about your library of movies where you gave a film a star or stars, that part of the database entry is called a userRating

You could write a script to query all your items in a library and sort by userRating

Then take that output and make an array of all videos (by ratingKey) which have
userRating>0

then use the API https://developer.plex.tv/pms/#tag/Rate to set the videos in that array to
userRating="0.0" (I haven’t tested it yet).

To get you started, this is how in my Movies library with librarySectionID=“1” I could do the initial search, assuming my token=1234567890abcdefg, in BASH.

curl -X GET "http://127.0.0.1:32400/library/sections/1/all?X-Plex-Token=1234567890abcdefg&sort=userRating:desc"

Items that you never rated are missing the userRating field entirely.
Whether that’s equal to userRating="0.0" I’ll leave as a treasure hunt.

good question :slight_smile: