User History Logger

Madsonic Mashup Mod is a fork of the Subsonic 4.7 Server Build 3090 with some Subsonic Data schema modifications!

Moderator: moderators

User History Logger

Postby vbguy2011 » Tue Mar 12, 2013 1:21 am

Hi, I understand there's a user history logger?

Could anyone explain what it is about, and how to use/access it?

Separately/additionally, is there a way to monitor user usage/statistic/activity? Would this be logged anywhere? If so, how can admin monitor/access?

Cheers
vbguy2011
 
Posts: 10
Joined: Tue Mar 12, 2013 1:18 am

Re: User History Logger

Postby MadEvil » Tue Mar 12, 2013 2:21 am

vbguy2011 wrote:Hi, I understand there's a user history logger?

Could anyone explain what it is about, and how to use/access it?
Separately/additionally, is there a way to monitor user usage/statistic/activity? Would this be logged anywhere? If so, how can admin monitor/access?
Cheers


the first version was an separately log file and log all user play history, in the 4.8 branche i changed to db-loging.

So you can easy show your own history or from others.

Image
Madsonic Developer
User avatar
MadEvil
 
Posts: 354
Joined: Wed Nov 09, 2011 8:35 pm
Location: Vienna

Re: User History Logger

Postby vbguy2011 » Tue Mar 12, 2013 3:31 am

Awesome!!!

However, couple things I note:
1) I don't have "other" or "self" but I have "ALL" as well as non-all which I believe are mine.
2) The username don't show

Separately, is there a way to monitor user activity/usage individually, i.e. view various stats for just 1 user instead of "ALL"/"other" users combined?

cheers
vbguy2011
 
Posts: 10
Joined: Tue Mar 12, 2013 1:18 am

Re: User History Logger

Postby MadEvil » Wed Mar 13, 2013 12:53 am

Hi there,

if you have simple SQL knowledge you can go to db.view and use this query

Code: Select all
SELECT * from statistic_user, media_file where statistic_user.media_file_id = media_file.id and username = 'admin'


this query should show you all information's about played entries incl. the username.

Image

best regards
Madsonic Developer
User avatar
MadEvil
 
Posts: 354
Joined: Wed Nov 09, 2011 8:35 pm
Location: Vienna

Re: User History Logger

Postby vbguy2011 » Wed Mar 13, 2013 2:47 am

MadEvil wrote:Hi there,

if you have simple SQL knowledge you can go to db.view and use this query

Code: Select all
SELECT * from statistic_user, media_file where statistic_user.media_file_id = media_file.id and username = 'admin'


this query should show you all information's about played entries incl. the username.

Image

best regards


Ah right, didn't realise I could do sql queries. that's great thanks!

that said, it would be nice to have a separate feature for monitoring user stastics/activity altogether instead of manually pulling SQL queries :)
vbguy2011
 
Posts: 10
Joined: Tue Mar 12, 2013 1:18 am


Return to Madsonic

Who is online

Users browsing this forum: No registered users and 21 guests