> Does anyone have a way to determine the total amount of files and data
> used by a specific file type across the server?  In particular, mp3's
but
> there are other questionable data types.


Try this one... However I got no idea if includes just active or both
active and inactive files, copypool and so on.

SELECT CAST(SUM(FILE_SIZE/1024/1024) AS DECIMAL (1000,0)) AS TOT_MP3_MB
FROM CONTENTS WHERE UPPER(FILE_NAME) LIKE '%.MP3'

regards,
Anders Pontusson