[EP-tech] sum of files-size belonging to one eprint/course

[Stenger, Avischai]

Hi all,

i would like to get a monthly Email with statistics about the size used on the hard disk for each „course“.

Is there a way to find the size of ALL files belonging to one eprint ? 
all files belonging to all eprints belonging to one „course“?

i tried getting it direct out of the database but it seams there is no unique connection between an eprint-record and the files-records uploaded for it (the connection i found was field „fileinfo“ in eprint-table, but as a „filename“ in file-table is not unique, this dosen’t really help) 




Tanks



Avi