Playback Reporting

[TeamB 2438]

4 hours ago, Happy2Play said:

I will guess all before this option was added.  Or are they still recorded and just ignored for stats?

Ignore play sessions less than x seconds in duration

 

yes correct, the action is still recorded but ignored when the report pages are calculated.

[TeamB 2438]

8 hours ago, vaise said:

I just wanted to create a Top 10 user list.  Not sure if I can trust the seconds watched.  Then I figured I could do it by number of plays….. but there are shed loads of ‘plays’ of 0 seconds (but the setting in the app is set to register not if more than 180 seconds minimum is used).  

Maybe I should delete those ?  Or all plays less that 180 seconds…..

you can delete then or just ignore then in your query, where playtime > 30

[TeamB 2438]

On 3/24/2024 at 6:58 PM, vaise said:

Found the issue - checkout these PauseDurations - 

 

i just found a bunch in my system with similar situation with the pause duration and the play duration almost identical or off by a few seconds.

and i have a lot of these, hundreds, for one movie in particular over a 3 week period, all from the web client, all direct play, all for 20 to 40000 seconds that look like they were paused the whole time.

i have no idea what is going on.

[vaise 340]

11 minutes ago, TeamB said:

i just found a bunch in my system with similar situation with the pause duration and the play duration almost identical or off by a few seconds.

and i have a lot of these, hundreds, for one movie in particular over a 3 week period, all from the web client, all direct play, all for 20 to 40000 seconds that look like they were paused the whole time.

i have no idea what is going on.

Yeah - I'm thinking various emby versions / emby clients / betas, busted stuff etc means the seconds played cant be trusted with all this.

There is no way it can be accurate - seems just too much there.  Even for the last month.  I went and updated anything with an episode to just be 30 minutes also - 

I was toying with wiping the data and restarting - but there is so much there that would be a pity.

[TeamB 2438]

SELECT DateCreated, ItemId, ItemType, ItemName, PlaybackMethod, ClientName, DeviceName, PlayDuration, PauseDuration, PlayDuration - PauseDuration AS PlaybackTime
FROM PlaybackActivity 
WHERE PlayDuration - PauseDuration < 300
AND PlayDuration > 3600
ORDER BY DateCreated DESC
LIMIT 200

I have a movie the Web Client just brought up and paused continuously, I asked my wife about it, and she said she only played this once and then deleted the move. I have no idea why emby would do this.

The only thing I can think of is Emby was open in a tab on firefox and every time the Machine was put to sleep and woken up the playback was brought back up in paused state. No idea really, can reproduce it.

DateCreated	ItemId	ItemType	ItemName	PlaybackMethod	ClientName	DeviceName	PlayDuration	PauseDuration	PlaybackTime
2024-03-12 22:38:34.0924145	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	35583	35552	31
2024-03-11 23:09:24.1622736	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	38893	38862	31
2024-03-11 17:44:27.4461913	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	5238	5229	9
2024-03-11 09:37:45.7401435	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	3922	3919	3
2024-03-10 23:14:15.9831269	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	32801	32776	25
2024-03-09 23:15:27.2718327	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	42820	42788	32
2024-03-09 17:58:10.0455182	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	3837	3834	3
2024-03-08 22:59:45.1430209	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	53909	53855	54
2024-03-08 17:43:26.7506748	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	6417	6411	6
2024-03-08 13:57:16.2425563	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	5099	5095	4
2024-03-08 00:03:14.2119859	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	34209	34179	30
2024-03-07 19:35:00.7591839	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	5280	5274	6
2024-03-06 22:22:48.2313711	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	41209	41168	41
2024-03-06 16:51:10.8297168	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	12074	12061	13
2024-03-06 11:29:54.5806741	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	10316	10308	8
2024-03-05 22:57:31.5753419	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	32432	32402	30

[vaise 340]

45 minutes ago, TeamB said:

SELECT DateCreated, ItemId, ItemType, ItemName, PlaybackMethod, ClientName, DeviceName, PlayDuration, PauseDuration, PlayDuration - PauseDuration AS PlaybackTime
FROM PlaybackActivity 
WHERE PlayDuration - PauseDuration < 300
AND PlayDuration > 3600
ORDER BY DateCreated DESC
LIMIT 200

I have a movie the Web Client just brought up and paused continuously, I asked my wife about it, and she said she only played this once and then deleted the move. I have no idea why emby would do this.

The only thing I can think of is Emby was open in a tab on firefox and every time the Machine was put to sleep and woken up the playback was brought back up in paused state. No idea really, can reproduce it.

DateCreated	ItemId	ItemType	ItemName	PlaybackMethod	ClientName	DeviceName	PlayDuration	PauseDuration	PlaybackTime
2024-03-12 22:38:34.0924145	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	35583	35552	31
2024-03-11 23:09:24.1622736	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	38893	38862	31
2024-03-11 17:44:27.4461913	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	5238	5229	9
2024-03-11 09:37:45.7401435	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	3922	3919	3
2024-03-10 23:14:15.9831269	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	32801	32776	25
2024-03-09 23:15:27.2718327	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	42820	42788	32
2024-03-09 17:58:10.0455182	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	3837	3834	3
2024-03-08 22:59:45.1430209	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	53909	53855	54
2024-03-08 17:43:26.7506748	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	6417	6411	6
2024-03-08 13:57:16.2425563	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	5099	5095	4
2024-03-08 00:03:14.2119859	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	34209	34179	30
2024-03-07 19:35:00.7591839	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	5280	5274	6
2024-03-06 22:22:48.2313711	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	41209	41168	41
2024-03-06 16:51:10.8297168	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	12074	12061	13
2024-03-06 11:29:54.5806741	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	10316	10308	8
2024-03-05 22:57:31.5753419	113435	Movie	Just Like a Christmas Movie	DirectPlay	Emby Web	Firefox Windows	32432	32402	30

I have about 15 that showed up with that query - I have deleted them......

 

[TeamB 2438]

14 minutes ago, vaise said:

I have about 15 that showed up with that query - I have deleted them......

are they recent? do you have emby server logs covering the times that they occurred?

Edited March 26, 2024 by TeamB

[Happy2Play 9780]

My 17 are from a remote user in 2021.

[yoyo77yo 28]

hello, in "playback reporting" => "summer" tab, I would like you to be able to filter on the column which indicates "Film", "audio" and "episode" in order to filter who watches films for example. Currently this filter does not exist. THANKS

[rbjtech 5284]

3 minutes ago, yoyo77yo said:

hello, in "playback reporting" => "summer" tab, I would like you to be able to filter on the column which indicates "Film", "audio" and "episode" in order to filter who watches films for example. Currently this filter does not exist. THANKS

Why not just create, and save, your own Custom Query - that's what it is there for..    There are some example custom queries in the drop down box.

 

[TeamB 2438]

@yoyo77yo were you able to write a query that gave you the data you needed

[eraser8 55]

Hello!

I don`t know why but I can only see 1 user being reported. I cannot see all other user I have on my server. Do I need to activate something in each user?

 

Thanks

[Happy2Play 9780]

9 minutes ago, eraser8 said:

Hello!

I don`t know why but I can only see 1 user being reported. I cannot see all other user I have on my server. Do I need to activate something in each user?

 

Thanks

Do you have Ignored users shown in plugin settings?

[eraser8 55]

9 minutes ago, Happy2Play said:

Do you have Ignored users shown in plugin settings?

Thanks for the response.

 

No, I have nothing in the Ignored section.

 

 

 

Thanks a lot

 

[Happy2Play 9780]

1 minute ago, eraser8 said:

Thanks for the response.

 

No, I have nothing in the Ignored section.

 

 

 

Thanks a lot

 

Dev will probably need to see server log for a user playing something and not being recorded.  As that is the only option I know of to ignore users.

[eraser8 55]

3 hours ago, Happy2Play said:

Dev will probably need to see server log for a user playing something and not being recorded.  As that is the only option I know of to ignore users.

Alright! Thanks a lot

[horstepipe 422]

Hey folks,

having a user who has problems playing back one episodes. We are never available at the same time, so I want to check with the playback reporting plugin how he plays back the video (direct, transcoding etc.)

Unfortunately "Playback Method" is there in general, but there doesn't seem to be a way to see this for a specific user?

[Neminem 1518]

Try clicking on the color area.

Edited June 10, 2024 by jaycedk

[horstepipe 422]

Thanks will try that out 

[EmYaj 25]

On 1/12/2022 at 1:56 PM, rbjtech said:

SELECT * FROM PlaybackActivity
WHERE ItemName = 'The Matrix Resurrections'

Something like this as a Custom Report (SQL) will show every user ever to have watched 'The Matrix Resurrections' for example.

Possible query items (database Schema) is :-

I'm looking to do something similar to this but with TV Shows as a whole (not specific episodes).  So for example I'd like to know when the most recent stream of a specific TV Show was.

(disclaimer, I have no idea what im doing).

What I came up with that seems to work for Movies is below.  The problem is I dont really care about movies I care about TV Shows and for Shows it shows the whole episode name starting with the Show name so I've tried using an asterisk (*) after the itemname but not sure if thats supposed to work or what the correct format should be.

 

SELECT *
FROM PlaybackActivity
WHERE ItemName = "Ford v Ferrari"
ORDER BY DateCreated DESC
LIMIT 25

Edited June 19, 2024 by EmYaj

[TeamB 2438]

you want to use the sql like matcher, it uses wild card %

where itemname like 'show name%'

[EmYaj 25]

On 6/19/2024 at 1:28 AM, TeamB said:

you want to use the sql like matcher, it uses wild card %

where itemname like 'show name%'

You're a legend, thank you.

If anyone needs this in the future, this works:

SELECT *
FROM PlaybackActivity
WHERE ItemName like 'Show Name%'
ORDER BY DateCreated DESC
LIMIT 10

Edited June 20, 2024 by EmYaj

[EmYaj 25]

Thought I'd be able to figure this one out based on what I learned reading through this thread but I'm out of my depth unfortunately.  If anyone is willing to help it would be appreciated.

I'm trying to output the total 'TvChannel' (LiveTV) watchtime broken down by UserId over a period of the previous 1 month.

[TeamB 2438]

Aggregation can be a little tricky, try this

SELECT UserId, SUM(PlayDuration - PauseDuration) AS PlayTime
FROM PlaybackActivity
WHERE ItemName like 'The Blacklist%'
AND DateCreated >= '2024-01-01' AND DateCreated < '2025-01-01'
GROUP BY UserId

 

[EmYaj 25]

1 hour ago, TeamB said:

Aggregation can be a little tricky, try this

SELECT UserId, SUM(PlayDuration - PauseDuration) AS PlayTime
FROM PlaybackActivity
WHERE ItemName like 'The Blacklist%'
AND DateCreated >= '2024-01-01' AND DateCreated < '2025-01-01'
GROUP BY UserId

 

I was able to adjust and get it working exactly how I wanted it, thank you!!

If anyone else needs something similar, this worked for me:

SELECT UserId, SUM(PlayDuration) AS PlayTime
FROM PlaybackActivity
WHERE ItemType like 'TvChannel'
AND DateCreated between date('now', 'start of day','-1 months') and date('now', 'start of day', '+1 day')
GROUP BY UserId
ORDER BY PlayTime DESC