recently added email notification

[disgustipated]

i had been considering writing a script for my freenas box that would pull files from one of my folders and treat that as an import folder. it would parse through the id3 tags, drop them in a temp folder if the naming convention and id3 tags are not up to par and then put valid ones into the proper directory structure on my NAS. when it would put valid ones into the proper folders on my NAS I was thinking of generating an email with a list of the albums and tracks added. This is where subsonic comes in, I was thinking it would be great to be able to have the ability for subsonic to actually send an email since it already seems to have a list of things recently added. I would hope to maybe see like a schedule to send emails something like maybe based on every day or once at least 5 new albums have been addded or something like that and have it subscription based so not all users are spammed with it if they dont want to be concerned with it.

is there a way to query the jetty database directly?