| Author |
 Topic  |
|
|
mqh7
Yak Posting Veteran
58 Posts |
 Posted - 10/08/2012 : 17:05:55
|
From the SCCM view called v_GS_LOGICAL_DISK I am retrieving the HD size and the available free disk space. How/where would I convert the returned numbers into a MB and/or GB format? I looked at the CONVERT function but it says "The CONVERT() function is a general function that converts an expression of one data type to another." and I want to keep it numbers....
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
mqh7
Yak Posting Veteran
58 Posts |
Posted - 10/08/2012 : 17:49:14
|
Here is an example of what it returns.
Computer Name Model Device ID Free Disk Space Actual Disk Size Description Primary Partition
84-pc-b67 HP Compaq 8200 Elite USDT PC C: 209763 228232 Local Fixed Disk 1
|
 |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
mqh7
Yak Posting Veteran
58 Posts |
Posted - 10/08/2012 : 18:20:25
|
| Instead of a number I wanted it to say "Free Disk Space = 45GB" Vs just a number (for management you see!!) |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
| |
Topic |
|
how to convert numbers?
