I realise this thread is old but it is still worth answering.

The below query will give you the space of offline databases.

SELECT

DB_NAME(db.database_id) as [DB Name],

CONVERT(DECIMAL(6,3),SUM((CONVERT(DECIMAL(20,5),mf.size)*8)/1048576)) as [DB Size in GB]

FROM

sys.databases...