select distinct @@servername, convert(varchar,a.backup_start_date,101) 'Date', a.database_name 'DB Name',

convert(decimal(7,2),round(sum(b.file_size/1024/1024/1024),3)) as 'Database Size in(GB)'

frommsdb..backupset a

inner join msdb..backupfile b on a.backup_set_id = b.backup_set_id

whereconvert(varchar,a.backup_start_date,101) = convert(varchar,getdate(),101)

and a.database_name in ( select name from sys.databases where database_id not in(1,2,3,4))

and a.type = 'd'

and b.file_type = 'd' and is_snapshot = 0

group by a.backup_set_id, a.database_name, a.backup_start_date

order by 1--, physical_name

replace getdate with the date you want , this will list datewise, DB wise size and i have excluded sys databases.