--================Show Database Log and Data file used space in GB
Select 
	DB_NAME(myDBFiles.database_id) as DatabaseName
	,CASE type 
		WHEN 0 THEN 'Data'
		WHEN 1 THEN 'Log'
	END as FileType
	,ROUND(CAST(SUM(myFileProperty.BytesOnDisk) as float)/(1024*1024*1024),2) as [FileSize(GB)]
from 
	sys.master_files as myDBFiles
	CROSS APPLY sys.fn_virtualfilestats(myDBFiles.database_id,myDBFiles.file_id) as myFileProperty
--WHERE
--	database_id>4
GROUP BY
	database_id
	,type
ORDER BY
	DatabaseName
	,FileType