Jump to content

Playback Reporting


TeamB

Recommended Posts

back it up now and it will give you a TSV file to play with, you can edit it and then re-import it.

 

 

 

Link to comment
Share on other sites

  • 1 month later...

@TeamBI am looking for a query that will report on movies or tvshows that were never played if someone could assist.  Thanks in advance for your time. 

Edited by griam01
Link to comment
Share on other sites

2 hours ago, griam01 said:

@TeamBI am looking for a query that will report on movies or tvshows that were never played if someone could assist.  Thanks in advance for your time. 

Sorry that is not possible. The plugin keeps records of what is played by who and when, it does not know anything about what has not been played so can not report on that.

 

Link to comment
Share on other sites

  • 5 weeks later...

hey @TeamB is it possible to get some alignment around what Emby reports as 'Direct Play' and what the Playback Reporting plugin reports as 'Direct Stream' ?

Example, I have two sessions running currently, which Emby sees as 'Direct Play':

image.png.4e521c4d18f0cfa04d75aa6364d5ad1f.png

 

However if I look in the Playback Reporting active sessions, it reports them as 'Direct Stream':

image.png.f0bf58bab4af13b276b592d5f13870ac.png

 

This obviously skews the reporting somewhat, but the plugin is able to report 'Direct Play' correctly for some (i just don't know when)
image.png.d028776266b387a72cba8c5869feded6.png

TIA!

Link to comment
Share on other sites

the plugin just uses the text from the session it gets from Emby, it is using what emby server thinks it is doing, it does not try to apply any logic itself.

https://github.com/faush01/playback_reporting/blob/54bfa5ab97452d8ad6e65492e9b2d2a822c39e7d/playback_reporting/EventMonitorEntryPoint.cs#L270

play_method = session.PlayState.PlayMethod.Value.ToString();

As you can see it is not applying any logic to the session info.

  • Thanks 1
Link to comment
Share on other sites

35 minutes ago, TeamB said:

As you can see it is not applying any logic to the session info.

I see. Thanks for the info.

So I guess this is a question for @Luke then, is there a reason the Dashboard reports something different to the underlying session info?

image.png.208097954acafc3936b02f9905057521.png


And in that case, what defines a true 'Direct Play' as is reported sometimes?

Link to comment
Share on other sites

8 hours ago, seanbuff said:

I see. Thanks for the info.

So I guess this is a question for @Luke then, is there a reason the Dashboard reports something different to the underlying session info?

image.png.208097954acafc3936b02f9905057521.png


And in that case, what defines a true 'Direct Play' as is reported sometimes?

No conversion means direct.

Link to comment
Share on other sites

  • 3 weeks later...

I just want to say thanks for the great plugin! This looks like it'll plug the Tautulli shaped hole I had from migrating from Plex.

Quick question, is there a place I can see the database schema so I can write my own queries easier?

Thanks again!

Link to comment
Share on other sites

on the query tab just use the simple saved query to select * from the table to give you all the fields, there is only one table.

  • Thanks 1
Link to comment
Share on other sites

By the way, do any of you have any cool SQL queries?

Here are mine:

- Count unique users per day

SELECT date(DateCreated) AS Date, COUNT(DISTINCT UserId) as Users
FROM PlaybackActivity WHERE DateCreated between date('now', 'start of day','-6 months') and date('now', 'start of day', '+1 day')
GROUP BY date(DateCreated)
ORDER BY date(DateCreated) ASC

 

- Count unique users per month

SELECT DISTINCT strftime('%Y-%m', DateCreated) AS Date, COUNT(DISTINCT UserId) as Users
FROM PlaybackActivity WHERE DateCreated between date('now', 'start of day','-24 months') and date('now', 'start of day', '+1 day')
GROUP BY Date
ORDER BY Date ASC

 

If you want to display a graph like this you must set these options :

image.png.ea54d75220e6a9bd8bb43d8a8f0525b7.png

 

image.png.e6000300c5c4f7ae104ce636d3dbc82d.png

Edited by Thuzad
  • Like 1
Link to comment
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...