TeamB 2353 Posted March 24 Author Share Posted March 24 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. Link to comment Share on other sites More sharing options...
TeamB 2353 Posted March 24 Author Share Posted March 24 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 Link to comment Share on other sites More sharing options...
TeamB 2353 Posted March 25 Author Share Posted March 25 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. Link to comment Share on other sites More sharing options...
vaise 307 Posted March 25 Share Posted March 25 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. Link to comment Share on other sites More sharing options...
TeamB 2353 Posted March 26 Author Share Posted March 26 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 Link to comment Share on other sites More sharing options...
vaise 307 Posted March 26 Share Posted March 26 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...... Link to comment Share on other sites More sharing options...
TeamB 2353 Posted March 26 Author Share Posted March 26 (edited) 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 by TeamB Link to comment Share on other sites More sharing options...
Happy2Play 8296 Posted March 26 Share Posted March 26 My 17 are from a remote user in 2021. 1 Link to comment Share on other sites More sharing options...
yoyo77yo 14 Posted April 9 Share Posted April 9 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 Link to comment Share on other sites More sharing options...
rbjtech 4284 Posted April 9 Share Posted April 9 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. 1 Link to comment Share on other sites More sharing options...
TeamB 2353 Posted April 9 Author Share Posted April 9 @yoyo77yo were you able to write a query that gave you the data you needed Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now