Re: SQL select question
2003-10-31 05:33:16
> 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
|
|
|