Need some help doing download reports

jfriend

In this thread, I was asking for some help figuring out how to generate a report that tells me which originals are getting downloaded. I have Star Explorer and know that it can collect download statistics and put them in a database, but I have no idea what to do with that data once it's in the database.

Here's the report I was looking for, sorted by # of originals downloaded, limited to activity in the last month. To see what image it is, I need to see a thumbnail since I don't know one image ID from another. I was hoping Smugmug could do something like this on their site, but it looks like doing something with the downloaded statistics is my only hope.

Any ideas?

Image                     Filename         # Originals Downloaded
--------------            ---------        -----------------------
[Thumbnail 1]             JLF_8592.JPG               12
[Thumbnail 2]             JLF_8588.JPG                9
[Thumbnail 3]             JLF_8422.JPG                7

Andy

Nik gave some help here, too:

http://www.dgrin.com/showthread.php?t=48985