topic Re: struggling to get sum of volumes & luns in Microsoft Virtualization Discussions

struggling to get sum of volumes & luns

sakalava — Thu, 19 Oct 2023 21:39:46 GMT

Hello All,

I am attempting to create a script which will add up the total available and used size of all volume

here is my script

$vols = Get-NcVol
$voltotal = $vols | Measure-Object -Property TotalSize -Sum
$voltotalsize = ConvertTo-FormattedNumber $voltotal.sum DataSize -Verbose
$volused = $vols | Measure-Object -Property Used -Sum
$volusedsize = ConvertTo-FormattedNumber $volused.sum DataSize -Verbose

It is giving me wrong numbers I think this is because the get-ncvol give volume size in Gb,Tb and Mb so we basically can not add apple to orange

Has anyone everdone that ? can you give me an exemple ?

Re: struggling to get sum of volumes & luns

sakalava — Thu, 19 Oct 2023 21:44:38 GMT

>Please ignore my post I did put it in the wrong forum category

Re: struggling to get sum of volumes & luns

TzwaynY — Wed, 25 Oct 2023 11:47:00 GMT

Hi there,

even tho, you want this topic to be closed, I can give you (hopefully) the answer you want.

For the Ontap Tools it does not matter if the size of the luns/volumes are in TB,GB, Gib, Mib or anything. You always get the "raw" bits and bytes as output from the Cmdlet.

I think, you want something like this?

$VolTotalSize = $null

$VolUsedSize = $null

$GetNcVols = Get-NcVol

foreach($Vol in $GetNcVols){

$VolTotalSize = $VolTotalSize + $Vol.TotalSize

$VolUsedSize = $VolUsedSize + $Vol.Used

}

Write-Host "Used-Capacity: $VolUsedSize`nTotal-Capacity: $VolTotalSize`nFree-Capacity $(($VolTotalSize - $VolUsedSize) / 1048576)"

I think? That is what you want. If you have any questions, feel free to ask, if anything is unclear (or if I understood it wrong :D)

Best regards

Kai

Re: struggling to get sum of volumes & luns

TzwaynY — Wed, 25 Oct 2023 12:01:27 GMT

Quick Edit: There you also have to divide the variables by 1048576.

Write-Host "Used-Capacity: $VolUsedSize`nTotal-Capacity: $VolTotalSize`nFree-Capacity $(($VolTotalSize - $VolUsedSize) / 1048576)"

So like that:

Write-Host "Used-Capacity: $($VolUsedSize /1048576 )`nTotal-Capacity: $($VolTotalSize / 1048576)`nFree-Capacity $(($VolTotalSize - $VolUsedSize) / 1048576)"

Note: This will give you the excact MB-Rate of the Volumes. After this, you can divide it further with the "normal" powershell dividing.
Best regards

Kai