Hello Team,

I am using below query to get size_mb and unused space in database

Is there any way to get instance level or report ?

Query:

select

a.FILEID,

[FILE_SIZE_MB] =

convert(decimal(12,2),round(a.size/128.000,2)),

[SPACE_USED_MB] =

convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),

[FREE_SPACE_MB] =

convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,

NAME = left(a.NAME,15),

FILENAME = left(a.FILENAME,30)

from

dbo.sysfiles a

Result

---------

Field id FILE_SIZE_MB Space_used_mb free_space_mb name filename

14.00 2.94 1.06 masterC:\Program Files (x86)\Microso

21.25 0.64 0.61 mastlogC:\Program Files (x86)\Microso

Kindly help me

Thanks in advance