YEs , It's fixed. Thanks Gila...

select a.[Database Name],a.[Type],a.[Size in MB],b.LastUserUpdate

from

(

SELECT [Database Name] = DB_NAME(database_id),

[Type] = CASE WHEN Type_Desc = 'ROWS' THEN 'Data File(s)'

WHEN Type_Desc = 'LOG' THEN 'Log File(s)'

ELSE Type_Desc END,

[Size in MB] = CAST( ((SUM(Size)* 8) / 1024.0) AS DECIMAL(18,2) )

FROM sys.master_files

GROUP BY GROUPING SETS

(

(DB_NAME(database_id), Type_Desc),

(DB_NAME(database_id))

)

--ORDER BY DB_NAME(database_id), Type_Desc DESC

) as a

left join

(select max(last_user_update) as LastUserUpdate,[Database Name] = DB_NAME(database_id) from sys.dm_db_index_usage_stats

group by database_id ) as b on a.[Database Name]= b.[Database Name]