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]
Thanks.