There are plenty of examples online abut getting information such as size, location etc. using a script, i have read myself quite a few, then i decided to write one
which i would give me what i needed, but it had to be simple. Using ideas from some scripts I found, it wrote this one, in the mind that we get and we give to each other,
this script is besides being helpful to me, written also to others so that they can do exactly what I did, modify it and end up with a script fit to their needs. I am not into the writing of articles, anymore, but if I ever feel i need to write I will, for now I hope this script (very simple) helps you. I have included some comments, because that's the part I mostly worked out myself (formulas), some of the scripts I found were not quite there giving the info as far as numbers, they used approximations etc. One thing you can do is add another column with similar function to give you TerraBytes usage.
The cross join, well you could also use a temporary table etc, is probably better, did not bother much, just plugged it in. It is for getting Disk size etc..