sql server database size report

SELECT * INTO #T1 FROM sys.sysfiles;
DELETE FROM #T1;
EXECUTE sp_msforeachdb 'INSERT INTO #T1 SELECT * from ?.sys.sysfiles'

select ( size * 0.00000762939453125 )as SizeGB , * from #t1
order by size desc