how to convert to get proper output?


  • 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?"

    Tuesday, March 04, 2014 5:03 PM


All replies