Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
mqh7
Yak Posting Veteran
58 Posts |
Posted - 2012-10-08 : 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
38200 Posts |
|
mqh7
Yak Posting Veteran
58 Posts |
Posted - 2012-10-08 : 17:49:14
|
Here is an example of what it returns.Computer Name Model Device ID Free Disk Space Actual Disk Size Description Primary Partition84-pc-b67 HP Compaq 8200 Elite USDT PC C: 209763 228232 Local Fixed Disk 1 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
mqh7
Yak Posting Veteran
58 Posts |
Posted - 2012-10-08 : 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
38200 Posts |
|
|
|
|