DBC.DiskSpace

sel

databasename,

sum(maxperm) AS MAXPERM,

sum(currentperm) AS CURRNETPERM,

sum(currentperm)*1.0/nullifzero(sum(maxperm)) AS USAGE

from

DBC.DiskSpace

group by 1

order by 2 desc

Tweet