I am creating a custom query against a SCCM 2007 DB. I have this under my SELECT statement
ld.FreeSpace0 AS [Free Disk Space],
ld.Size0 AS [Actual Disk Size],
x86.TotalPhysicalMemory0 AS [Total Memory],
I get the correct information in my output but it shows like this.
ld.FreeSpace0 = 226484
ld.Size0 AS = 238409
x86.TotalPhysicalMemory0 = 3108372
how do I make the output read "xxxxxx GB free?"