Darkseidd 59 Posted February 2, 2023 Posted February 2, 2023 33 minutes ago, TeamB said: there is no option to ignore or include only certain libraries thanks for the swift response @TeamB
TeamB 2397 Posted February 2, 2023 Author Posted February 2, 2023 I have noticed some weird anomalies in some of the data logged in my setup with very long play duration times, I am not sure if this is a bug in the plugin or just weirdness in general in how my users (family) are using the system. It would be helpful if a few people could run the following SQL in the Query tab and post the results SELECT DateCreated, ItemType, PlaybackMethod, ClientName, PlayDuration/60 as PlayDuration, PauseDuration/60 as PauseDuration, (PlayDuration - PauseDuration) / 60 AS PlayTime FROM PlaybackActivity ORDER BY PlayDuration DESC LIMIT 20
seanbuff 1026 Posted February 3, 2023 Posted February 3, 2023 15 minutes ago, TeamB said: It would be helpful if a few people could run the following SQL in the Query tab and post the results I have quite a number of results of instances that I know had "stuck" or really long sessions due to the client, namely Chromecasts or Apple TV not killing sessions. DateCreated ItemType PlaybackMethod ClientName PlayDuration PauseDuration PlayTime 2022-02-03 14:42:16.2877501 Movie Transcode Emby Web 5931 0 5931 2021-04-28 14:33:02.100978 Movie DirectPlay Emby for Chromecast 4413 4406 6 2021-08-22 15:27:50.9068987 Episode Transcode Emby for Chromecast 4008 3999 8 2021-05-16 20:46:35.9514914 Movie Transcode Emby for Chromecast 3567 3556 11 2021-05-04 10:12:52.4353132 Movie DirectPlay Emby for Chromecast 3549 3545 4 2021-08-25 10:16:45.666458 Episode DirectPlay Emby for Chromecast 3414 3407 6 2021-08-25 14:08:26.9521726 Movie Transcode Emby for Chromecast 3244 3189 55 2021-05-13 08:58:41.5000006 Movie DirectPlay Emby for Chromecast 2942 2939 3 2021-05-31 17:29:30.7572282 Movie Transcode Emby for Chromecast 2785 2653 131 2021-04-26 17:46:46.6001276 Movie Transcode Emby for Chromecast 2685 2577 107 2021-04-05 17:10:50.9622608 Movie Transcode Emby for Chromecast 2611 2521 90 2021-06-02 15:55:41.9301984 Movie DirectPlay Emby for Chromecast 2525 2522 3 2021-05-29 16:14:03.028603 Movie Transcode Emby for Chromecast 2438 2402 36 2021-03-28 19:23:58.7294694 Movie Transcode Emby for Windows 2350 2290 59 2021-12-04 01:26:19.0354803 Movie DirectStream tvOS 2220 2217 3 2021-09-18 23:04:54.1435392 Movie Transcode Emby for Chromecast 2103 2039 64 2021-08-02 08:11:15.9556284 Movie Transcode Emby for Chromecast 1994 1920 74 2021-05-15 12:35:23.9071298 Movie DirectPlay Emby for Chromecast 1931 1925 5 2022-07-20 17:45:49.01701 Episode DirectStream Emby for Apple TV 1859 1852 6 Nothing really recent though. 1
Happy2Play 9204 Posted February 3, 2023 Posted February 3, 2023 13 minutes ago, TeamB said: I have noticed some weird anomalies in some of the data logged in my setup with very long play duration times, I am not sure if this is a bug in the plugin or just weirdness in general in how my users (family) are using the system. It would be helpful if a few people could run the following SQL in the Query tab and post the results SELECT DateCreated, ItemType, PlaybackMethod, ClientName, PlayDuration/60 as PlayDuration, PauseDuration/60 as PauseDuration, (PlayDuration - PauseDuration) / 60 AS PlayTime FROM PlaybackActivity ORDER BY PlayDuration DESC LIMIT 20 Looks like older entries release server beta server 1
TeamB 2397 Posted February 3, 2023 Author Posted February 3, 2023 (edited) Thanks, yeah there are a lot of really high numbers in there, 5931 and 22129 minutes!!! It could very well be that the emby server thinks it is serving this file for that long and in that case there is not a lot I can do but I will need to go back and have a look at this, might need change how I track this. Edited February 3, 2023 by TeamB
Happy2Play 9204 Posted February 3, 2023 Posted February 3, 2023 (edited) 2 hours ago, TeamB said: Thanks, yeah there are a lot of really high numbers in there, 5931 and 22129 minutes!!! It could very well be that the emby server thinks it is serving this file for that long and in that case there is not a lot I can do but I will need to go back and have a look at this, might need change how I track this. Is it possibly cumulative playcount? That user shows they played that episode 3 times. duration is not exact but close 179478000000 / 60 = 2,991,300,000 (2991 from above) 179478000000 = 0 Days + 4 Hours + 59 Minutes + 7.8 Seconds / 3 = 0 Days + 1 Hour + 39 Minutes + 42.6 Seconds item runtimeticks 51175630000 = 0 Days + 1 Hour + 25 Minutes + 17.563 Seconds But going back to that day Playback shows shows I guess the question becomes is this an issue now or in the past? 22129 User Playback Summary Start: 01/05/2000 End: 02/02/2023 8429 Days All Users Aggregate: Filter: The Mitchells vs. the Machines 2022-05-29 S Movie The Mitchells vs. the Machines 00:49:30 2022-04-22 S Movie The Mitchells vs. the Machines 03:58:20 2022-04-21 S Movie The Mitchells vs. the Machines 01:13:49 2022-03-06 S Movie The Mitchells vs. the Machines 01:31:30 2022-02-20 S Movie The Mitchells vs. the Machines 01:54:18 2021-12-27 S Movie The Mitchells vs. the Machines 02:00:56 2021-11-21 S Movie The Mitchells vs. the Machines 01:57:24 2021-10-16 S Movie The Mitchells vs. the Machines 368:49:35 2021-10-15 S Movie The Mitchells vs. the Machines 02:24:03 2021-08-05 Heather Movie The Mitchells vs. the Machines 01:42:58 2021-07-05 S Movie The Mitchells vs. the Machines 00:47:53 2021-07-04 S Movie The Mitchells vs. the Machines 00:00:00 2021-07-02 S Movie The Mitchells vs. the Machines 47:36:42 2021-06-30 S Movie The Mitchells vs. the Machines 01:20:24 Edited February 3, 2023 by Happy2Play
Darkseidd 59 Posted February 3, 2023 Posted February 3, 2023 5 hours ago, TeamB said: I have noticed some weird anomalies in some of the data logged in my setup with very long play duration times, I am not sure if this is a bug in the plugin or just weirdness in general in how my users (family) are using the system. It would be helpful if a few people could run the following SQL in the Query tab and post the results SELECT DateCreated, ItemType, PlaybackMethod, ClientName, PlayDuration/60 as PlayDuration, PauseDuration/60 as PauseDuration, (PlayDuration - PauseDuration) / 60 AS PlayTime FROM PlaybackActivity ORDER BY PlayDuration DESC LIMIT 20
TeamB 2397 Posted February 3, 2023 Author Posted February 3, 2023 2 hours ago, Happy2Play said: Is it possibly cumulative playcount? no, it is total of this play session, the play session is keyed on the following key = deviceId + "-" + userId + "-" + session_playing_id; so for a given session all play activity is tracked using the above key and playback duration and paused duration are aggregated for that session. 2 hours ago, Happy2Play said: duration is not exact but close 179478000000 / 60 = 2,991,300,000 (2991 from above) 179478000000 = 0 Days + 4 Hours + 59 Minutes + 7.8 Seconds / 3 = 0 Days + 1 Hour + 39 Minutes + 42.6 Seconds item runtimeticks 51175630000 = 0 Days + 1 Hour + 25 Minutes + 17.563 Seconds But going back to that day Playback shows shows but that 2991 is in minutes, so this is 49 hours 51 minutes 2 hours ago, Happy2Play said: I guess the question becomes is this an issue now or in the past? not sure but I am reasonable sure it is not a bug in the plugin, I have gone back over the code and the only way I can see this happening is if the server though a client was actually playing the files for that long and the session was kept open and in the play state for that long.
TeamB 2397 Posted February 3, 2023 Author Posted February 3, 2023 5 minutes ago, Darkseidd said: they look good, but it shows some long Paused durations, someone starting an episode pausing it for several hours and then watching the rest. 1
Happy2Play 9204 Posted February 16, 2023 Posted February 16, 2023 Just noticed this one for a 23m episode.
TeamB 2397 Posted February 16, 2023 Author Posted February 16, 2023 (edited) 45 minutes ago, Happy2Play said: Just noticed this one for a 23m episode. I get the feeling that the client is not sending the pause or the server is not correctly processing it so does not know the client is paused. This would look like above where the server thinks a user is playing an item but in reality it is paused for a very long time thus the long play time. Edited February 16, 2023 by TeamB 1
TeamB 2397 Posted February 19, 2023 Author Posted February 19, 2023 Latest version 2.0.0.0 - Added "Ignore short playback sessions" option - Updated UI, better layout, resized some components, better background colour (light/dark) compatibility - Lots of small bug fixes 1
Happy2Play 9204 Posted February 19, 2023 Posted February 19, 2023 2 hours ago, TeamB said: Latest version 2.0.0.0 - Added "Ignore short playback sessions" option - Updated UI, better layout, resized some components, better background colour (light/dark) compatibility - Lots of small bug fixes Should it reset all previous stats? Summary is still there.
TeamB 2397 Posted February 19, 2023 Author Posted February 19, 2023 29 minutes ago, Happy2Play said: Should it reset all previous stats? Summary is still there. no it should not reset any saved data or settings.
Happy2Play 9204 Posted February 19, 2023 Posted February 19, 2023 Any on else seeing an issue on Beta server? No charts working on 4.8.0.21 but everything works on 4.7.11.0
Happy2Play 9204 Posted February 20, 2023 Posted February 20, 2023 Not sure what happened but renamed the db and restored backup data and all charts are populating again.
TeamB 2397 Posted February 20, 2023 Author Posted February 20, 2023 1 hour ago, Happy2Play said: Any on else seeing an issue on Beta server? No charts working on 4.8.0.21 but everything works on 4.7.11.0 all dev and testing was on 4.8.0.21 beta with final release testing done on current stable. 1
Happy2Play 9204 Posted February 20, 2023 Posted February 20, 2023 1 minute ago, TeamB said: all dev and testing was on 4.8.0.21 beta with final release testing done on current stable. Yes as I was looking at another test beta system and it updated fine so I am not sure what happened on my primary beta but was an easy fix recreating the db and restoring backup tsv. All data was there, just was not creating any charts/graphics.
Happy2Play 9204 Posted February 20, 2023 Posted February 20, 2023 Actually, just found the issue @TeamBit is the Ignore duration as I set it to 120 seconds and it clears all charts. It clears charts with any duration selected. Removing Ignore populates.
Happy2Play 9204 Posted February 20, 2023 Posted February 20, 2023 Okay I miss read the setting as I was adding Ignored users thinking both were linked. Setting the duration value works.
TeamB 2397 Posted February 20, 2023 Author Posted February 20, 2023 1 hour ago, Happy2Play said: Okay I miss read the setting as I was adding Ignored users thinking both were linked. Setting the duration value works. do you think I need to make it clearer that these two options are seperate?
Happy2Play 9204 Posted February 20, 2023 Posted February 20, 2023 2 minutes ago, TeamB said: do you think I need to make it clearer that these two options are seperate? Maybe a little separation or flip the order. But technically should be self-explanatory if I actually read it completely. 1
Thorman 1 Posted February 20, 2023 Posted February 20, 2023 Why does the ignore users option not disable notifications from that user using the "user activity notification" scheduled task? I have a few users ignored in the playback reporting settings, and they don't show up in anything but in the summary list. Is that list what the notification looks at? Is there a way for ignored users not to show up in the summary list so my notifications aren't triggering with users I have ignored?
xiaobaiya 6 Posted February 20, 2023 Posted February 20, 2023 Hello, I have been using playback_reporting for over a year and am a loyal user from China. However, I have been troubled by an issue regarding time zones. I installed EMBY on Docker, and even though I have set the parameter to TZ=CST-8 or TIMEZONE or TZ=Asia/Shanghai, I am still unable to set the time zone. The time displayed on the summary page is always 8 hours behind China time, for example, if my viewing record at 16:00, it shows as 8:00 in the summary. However, the time displayed on the Activity page provided by EMBY is correct. Can you please let me know if there is an issue with my settings or if the plugin is not detecting the time zone?
TeamB 2397 Posted February 20, 2023 Author Posted February 20, 2023 4 hours ago, Thorman said: Why does the ignore users option not disable notifications from that user using the "user activity notification" scheduled task? its probably a bug, thanks for reporting, I will look into it.
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