Help needed for reporting album history on LMS

[Ecoman68]

Hello,

i want to create a report, which contains all played albums in the last mounth. Are there any tools or helpfull SQL-statements available for LMS?

At the LMS-database i've only found the table "track_statistics". But it only contains informations like, when a title was played last time, how often the title was played since the server was installed ("playCount") and so on.

I've searched the forum and for a good plugin, but found nothing - perhaps i did't use the right keywords!?

Please, please help me!

Thanks a lot! ;-)

Cu,
Ecoman68

[aubuti]

Try the PlayLog plugin. It generates a report that you can view in the LMS web interface, and you can output it as XML or m3u.

EDIT: By default, PlayLog will report a running log of every track played, along with artist, album, date played, name of player, and URL. If you only want album totals then you'll have to do some massaging of the output or modifications to the plugin code.