/ Published in: DOS Batch

Run this from within SQL Server to get free space on a drive into a table.
See http://snipplr.com/view/8339/write-disk-space-to-table/ for SQL.
Expand |
Embed | Plain Text
Comments

You need to login to post a comment.
This DOS batch job works a treat, but would like to fine tune further if possible. When I run this I get free disk space figures like for example 1987654321 (=1.98gb) or 21987654321 (=21.98gb) or 321987654321 (=321.98gb). Ideally I want to break down the free disc space return value into a MB or GB figure, as I have shown above. Can anyone help? Secondly need a similar DOS batch to shown me disk size.
This DOS batch job works a treat, but would like to fine tune further if possible. When I run this I get free disk space figures like for example 1987654321 (=1.98gb) or 21987654321 (=21.98gb) or 321987654321 (=321.98gb). Ideally I want to break down the free disc space return value into a MB or GB figure, as I have shown above. Can anyone help? Secondly need a similar DOS batch to shown me disk size.
This DOS batch job works a treat, but would like to fine tune further if possible. When I run this I get free disk space figures like for example 1987654321 (=1.98gb) or 21987654321 (=21.98gb) or 321987654321 (=321.98gb). Ideally I want to break down the free disc space return value into a MB or GB figure, as I have shown above. Can anyone help? Secondly need a similar DOS batch to shown me disk size.