SET NOCOUNT ON
DECLARE @upSince DATETIME
SET @upSince = (SELECT TOP 1 crdate FROM master.sys.sysdatabases WHERE name='tempdb')
SELECT CAST(GETDATE()-@upSince AS BIGINT) AS uptime_in_days

SELECT dbs.name, vfs.FileID, vfs.NumberReads, vfs.IoStallReadMS, vfs.NumberWrites,
           vfs.BytesWritten/1024 AS KB_Written, vfs.IOStallWriteMS,
           vfs.BytesOnDisk/1024 AS KB_On_Disk_Now

FROM fn_virtualfilestats(null,null) vfs
LEFT JOIN master.sys.sysdatabases dbs ON vfs.DBId = dbs.dbid
WHERE name NOT IN ('master','msdb','model','tempdb')
ORDER BY name ASC