Jump to content

Playback Reporting - breakdown series by playcount


daedalus

Recommended Posts

i'm trying to figure out, what episodes of a specific series got played the most

i thought this could be achieved by the playback reporting plugin, but i can't even find any way to show any playcounts at all

could someone please help out here how this could be done?

Edited by daedalus
Link to post
Share on other sites
PenkethBoy

its in the db userdatas table - has all played counts from db start

 

or look at the backup of the playback plugin its a tab delimited csv and do a count from that - although its only going to show what you have watched since you added it

Link to post
Share on other sites

db userdatas table only has them "encrypted" behind some ids, no easy task if not being familiar with db handling

urgh so playback reporting is collecting its "own" data, thought it would read that from the db

too bad there is no easy way

Edited by daedalus
Link to post
Share on other sites
PenkethBoy

This will give you a start - use the Execute SQL Tab in Db browser for sqlite - after you open the library.db

Select MediaItems.Id, MediaItems.type, MediaItems.name, MediaItems.UserDataKeyId, MediaItems.SeriesName, MediaItems.ParentIndexNumber, MediaItems.IndexNumber, UserDatas.playCount from MediaItems, UserDatas
where MediaItems.UserDataKeyId = UserDatas.UserDataKeyId
order by MediaItems.SeriesName, MediaItems.ParentIndexNumber, MediaItems.IndexNumber

5e5534f4ed825_Annotation20200225145223.j

 

@@daedalus

  • Like 1
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...