> 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
