Playback Reporting

[Jdiesel 1240]

Not sure if this plugin is still being actively developed but i wanted to make a FR for the ability to ignore/hide undefined clients from the actively connected clients page. Applications that are connected via the emby api will show up as undefined.

[rbjtech 4806]

1 hour ago, Jdiesel said:

Not sure if this plugin is still being actively developed but i wanted to make a FR for the ability to ignore/hide undefined clients from the actively connected clients page. Applications that are connected via the emby api will show up as undefined.

It also uses the API 'App Name' as the Device - so you should know what API/Key is connected. (if not, name your API Keys properly ..  )   

btw - being @TeamB, I believe the Plugin is open source. 

Edited August 6, 2024 by rbjtech

[Jdiesel 1240]

8 minutes ago, rbjtech said:

It also uses the API 'App Name' as the Device - so you should know what API/Key is connected. (if not, name your API Keys properly ..  )   

btw - being @TeamB, I believe the Plugin is open source. 

The connecting app shows up as the device but the user is still undefined

 

Either way i don't consider apps doing api call as playback reporting thus the reason for wanting to hide this information.

Edited August 6, 2024 by Jdiesel

[rbjtech 4806]

19 minutes ago, Jdiesel said:

The connecting app shows up as the device but the user is still undefined

It's not a 'user' ?

Can you give an example of what you are seeing and what you would like to see ?

In my example below - I can see my VideoPrePostProcessing script ran.  Other than it saying 'Emby API' instead of undefined - I'm not sure what more information it could provide ?

Edited August 6, 2024 by rbjtech

[Jdiesel 1240]

I see the same as your example, my preference would be to not show anything at all. I only want real clients in this view and am not concerned about connected apps. IMO it is too congested with all the ARRs, notifications, and other integrations i have setup.

[rbjtech 4806]

1 minute ago, Jdiesel said:

I see the same as your example, my preference would be to not show anything at all. I only want real clients in this view and am not concerned about connected apps. IMO it is too congested with all the ARRs, notifications, and other integrations i have setup.

Fair enough

I guess lets see what @TeamBsays - I'd imagine its relatively easy to just hide that 'user type' from the list. 

[Jdiesel 1240]

I figured it wouldn't be a stretch since you can already hide actual users. The undefined user doesn't show up in the dropdown though.

[TeamB 2392]

4 hours ago, Jdiesel said:

actively connected clients page

This comes directly from the server, it is the list of active sessions, i.e. a client is connected. This data is not stored anywhere, it is just a snapshot of what the server is seeing.

For the correct connected clients list you should always use the main Emby Admin Dashboard as this has a bunch of filtering for both client types and session status/age etc.

[EmYaj 19]

@TeamBI know you don't visit the forum too often so tagging you just in case that helps, hope thats OK

I'm trying to damnedest to figure out a way find a way to see the maximum number of concurrent livetv streams in the past 1 month and wondering if Playback Reporting would be able to calculate this somehow.

For example, my iptv account has a maximum of 10 concurrent streams, and I try to keep an eye on how many streams there are but it can be difficult and I cant watch the emby dashboard at all times so it would be really awesome if I could somehow pull a report that could just tell me for example "On Oct 1st there was a peak of 8 streams" (or, honestly, just and output of "8" would be just as useful). 

[TeamB 2392]

1 hour ago, EmYaj said:

@TeamBI know you don't visit the forum too often so tagging you just in case that helps, hope thats OK

I'm trying to damnedest to figure out a way find a way to see the maximum number of concurrent livetv streams in the past 1 month and wondering if Playback Reporting would be able to calculate this somehow.

For example, my iptv account has a maximum of 10 concurrent streams, and I try to keep an eye on how many streams there are but it can be difficult and I cant watch the emby dashboard at all times so it would be really awesome if I could somehow pull a report that could just tell me for example "On Oct 1st there was a peak of 8 streams" (or, honestly, just and output of "8" would be just as useful). 

the short answer is unfortunately no, the plugin can not do this.

while most of the data you need to calculate this is there in the stored info and you do have access to the data using the query tab to run sql queries against the data you would need extra processing of the data to get what you want.

one thing you could experiment with is exporting the data and using something like python to process the data to give you what you want.

[fahad92 6]

 

Hi @TeamB

Is there a solution for the wrong reading of movies and TV shows

I have some users were it shows they have watched one episode for 17 days which is wrong. It happened with multiple episodes.

I'm not sure how to get rid of these wrong reading.

The plugin version is 2.1.0.5 and I'm not sure where to find the new updates.

Emby 4.8.10.0

[TeamB 2392]

1 hour ago, fahad92 said:

 

Hi @TeamB

Is there a solution for the wrong reading of movies and TV shows

I have some users were it shows they have watched one episode for 17 days which is wrong. It happened with multiple episodes.

I'm not sure how to get rid of these wrong reading.

The plugin version is 2.1.0.5 and I'm not sure where to find the new updates.

Emby 4.8.10.0

the server can sometimes get into a weird state were it thinks a client is watching something when it is not, in this stuck state playback reporting will log that the user is watching something for many many hours or even days. the stuck sessions get removed on server restart but.

you have two option to remove the long playback items in the plugin. if you know sql you can use the query tab or find the long items in a users summary page and there is a delete button to delete them individually.

[fahad92 6]

44 minutes ago, TeamB said:

the server can sometimes get into a weird state were it thinks a client is watching something when it is not, in this stuck state playback reporting will log that the user is watching something for many many hours or even days. the stuck sessions get removed on server restart but.

you have two option to remove the long playback items in the plugin. if you know sql you can use the query tab or find the long items in a users summary page and there is a delete button to delete them individually.

Thank you for the quick response.

Can you please help me in the sql what kind of line I need to put.

+ Where to find any updates for the plugin. GitHub is outdated.

Edited October 17, 2024 by fahad92

[TeamB 2392]

45 minutes ago, fahad92 said:

Can you please help me in the sql what kind of line I need to put.

If you don't know SQL I would recommend you don't use this approach.

45 minutes ago, fahad92 said:

Where to find any updates for the plugin. GitHub is outdated.

The latest version is always available in the Emby Plugin Catalogue and should update automatically.

The latest source code for the plugin is always available in the GitHub repo for the plugin:

https://github.com/faush01/playback_reporting

Edited October 17, 2024 by TeamB

[Happy2Play 9140]

35 minutes ago, fahad92 said:

Thank you for the quick response.

Can you please help me in the sql what kind of line I need to put.

+ Where to find any updates for the plugin. GitHub is outdated.

You have to go back to page 11 to get the query and run the query and change dates and limit accordingly to get a list.

That will give you user and media title.

example

Go to Playback tab and dates to the date of that playback and click on appropriate user you can delete that long session

 

Or attempt to change the db values to try and normalize a little bit.

https://emby.media/community/index.php?/topic/85832-playback-reporting/&do=findComment&comment=1342860

 

[fahad92 6]

20 hours ago, Happy2Play said:

You have to go back to page 11 to get the query and run the query and change dates and limit accordingly to get a list.

That will give you user and media title.

example

Go to Playback tab and dates to the date of that playback and click on appropriate user you can delete that long session

 

Or attempt to change the db values to try and normalize a little bit.

https://emby.media/community/index.php?/topic/85832-playback-reporting/&do=findComment&comment=1342860

 

 

 

Thank you so much , I did the playback method and it did work to normalize things a bit.

[Jay1911 7]

Any chance someone could help me spit out a list of the Title of every TV Show that has been watched in the past X Months?

Edited October 26, 2024 by Jay1911

[Q-Droid 827]

You can try this:

SELECT distinct itemname
FROM PlaybackActivity
where itemtype = 'Episode'
and datecreated >= datetime('now','-6 months')
order by 1
 

Edited October 27, 2024 by Q-Droid

[Ansell 0]

Hello, I have some questions about your plug-in playback_reporting. There are some media libraries that I don’t want to add statistics. Is there a place to set it separately or add a name to each media library separately? There are some media libraries that I don’t want my family to see the playback record. It's a little embarrassing. You know what I mean. I hope it can be improved.playback_reporting 

[TeamB 2392]

Only admins in the system can see playback reporting data. If you are the admin on your severe, then no one else can see what you are watching.

There is no way to ignore certain libraries or items from the statistics.

[Neminem 684]

@TeamBIf @Ansellhas setup multipel notifications, with different revivers it possible.

But then op should limited revivers notification to exclude what op don't want to show

 

[MLMBB 0]

How to get old data for playback reporting before the time that intalled?

[MLMBB 0]

On 5/2/2020 at 5:01 AM, TeamB said:

Playback reporting plugin:

• View playback reports
• View user activity
• View performance and system usage

Install it from the Emby server plugin catalogue.

 

Source:

https://github.com/faush01/playback_reporting

 

Restoring data for recent (remote address) schema change

STOP this is destructive, back up your playback reporting data first.
stop emby server and take a copy of the playback_reporting.db DB before you start.

In the query tab run this to get a list of all the tables

SELECT name FROM sqlite_master

It should show a list of tables like this:

PlaybackActivity_20190525_085249
UserList
PlaybackActivity_20230425_063417
PlaybackActivity

the two tables you are interested in are

PlaybackActivity

and any table with the date sting in the end like

PlaybackActivity_20230425_063417

Edit the following query with the name you have in your above results (DONT USE MINE)

INSERT INTO PlaybackActivity
SELECT *, "" AS RemoteAddress FROM PlaybackActivity_<TABLE NAME HERE>
WHERE DateCreated NOT IN (SELECT DateCreated FROM PlaybackActivity)

This will import all the old data into the new table.

 

 

 

Can u show me how to do it with picture because i dont know how restore the old data

 

[TeamB 2392]

37 minutes ago, MLMBB said:

How to get old data for playback reporting before the time that intalled?

you can not, you can only see data since the plugin was installed.

13 minutes ago, MLMBB said:

Can u show me how to do it with picture because i dont know how restore the old data

 

if you have a backup log just use the restore action to restore the data. You dont need to run and SQL etc, just restore the data.

[MLMBB 0]

1 hour ago, TeamB said:

you can not, you can only see data since the plugin was installed.

if you have a backup log just use the restore action to restore the data. You dont need to run and SQL etc, just restore the data.

I Dont have restore data i want to do it with SQL please Teach Me