Look at stats about your collection from excel
Posted: Fri Jun 11, 2004 7:24 pm
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)
---------------------------------
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.dqyCode: 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