Subsonic Forum

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 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.

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

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.



best regards

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.



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