Look at stats about your collection from excel

[b0b0b0b]

Here's a simple query that I defined in msqry32.exe that, when run, generates an excel spreadsheet with the 200 artists in my collection that have the most songs.

Your mileage is probably going to vary-- some of the stuff in there looks like magic numbers.

However, I thought this was an interesting way of probing the monkey database without having to do a whole lot of work. (I hacked together an asp.net webapp to view the database, but that was not as simple as this thing is for sure)

Code: Select all

top200artists.dqy

---------------------------------

Code: Select all

XLODBC
1
DSN=MediaMonkey;DBQ=\\somecomputer\c$\mediamonkey.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
SELECT top 200 COUNT(1), artists.Artist  FROM `\\somecomputer\c$\mediamonkey`.Artists artists, `\\somecomputer\c$\mediamonkey`.Songs Songs  WHERE Songs.IDArtist = artists.ID  GROUP BY artists.Artist  ORDER BY count(1) desc


Expr1000	Artist