topic Aggregate report... in Microsoft Virtualization Discussions

Aggregate report...

kallu_chakri — Sat, 14 Dec 2013 15:29:14 GMT

Hi All, I will be greatful, if anyone could get my a powershell script for a report in the below format. (Aggregate Name) (Total Space (TB)) (Used Capacity (TB))(Allocated Capacity (TB)) (Space Available (TB)) Thanks, Kalyan Guturi.

Re: Aggregate report...

vinith — Sat, 14 Dec 2013 16:07:17 GMT

There is no need of a powershell script, single cmdlet would give you that info.

Get-NaAggr

Re: Aggregate report...

kallu_chakri — Sat, 14 Dec 2013 16:20:28 GMT

Vinith,

Thanks for the quick response. However, "Get-NaAggr" provides <total size> <used> and <Available> but doesn't provide allocated. Command "aggr show_space" provides all the mentioned information. How can we point this Get-NaAggr command to a specific filer.

Help here please....!

Re: Aggregate report...

vinith — Sat, 14 Dec 2013 16:29:34 GMT

Connect to the Controller first as below.

Connect-NaController <Controller IP Address> -Credential (Get-Credential)

Then try out Get-NaAggr

I guess you are a newbie to powershell toolkit, check out some of these documents.

https://communities.netapp.com/docs/DOC-6162

https://communities.netapp.com/docs/DOC-10684

Re: Aggregate report...

JimKoenig — Wed, 02 Dec 2015 18:54:01 GMT

You are correct by the way get-NaAgg doesn't contain the allocated amount... Did you ever find a Powershell command that would give the allocated amount? I am having the same issue where I am not able to find the allocated amount even on the cDOT systems using get-NcAgg. Thanks.

Re: Aggregate report...

asulliva — Wed, 02 Dec 2015 21:23:26 GMT

Something like this should produce the information you're looking for:

 Get-NcAggr | ForEach-Object {
    $x = "" | Select Name,Total_TB,Used_TB,Allocated_TB,Available_TB
    $x.Name = $_.Name
    $x.Total_TB = [Math]::Round($_.TotalSize / 1TB, 2)
    $x.Available_TB = [Math]::Round($_.Available / 1TB, 2)
    $x.Used_TB = [Math]::Round($_.AggrSpaceAttributes.SizeUsed / 1TB, 2)
    $x.Allocated_TB = 0

    Get-NcVol | ?{ $_.Aggregate -eq $x.Name } | %{ $x.Allocated_TB += $_.TotalSize }
    $x.Allocated_TB = [Math]::Round($x.Allocated_TB / 1TB, 2)

    $x
}

There is no single command or attribute which shows the allocated capacity against an aggregate. Instead you simply find all the volumes on that aggregate and sum their provisioned space.

Hope that helps.

Andrew

Re: Aggregate report...

Kirand1979 — Tue, 25 Oct 2016 23:44:17 GMT

can we add %overcommited in this ?

Re: Aggregate report...

asulliva — Thu, 03 Nov 2016 20:25:02 GMT

Hello @Kirand1979,

You can add in the commitment percent using this line:

$x.Committed_Percent = [Math]::Round(($x.Allocated_TB / $x.Total_TB) * 100)

Don't forget to add the "Committed_Percent" field to the object declaration too.

$x = "" | Select Name,Total_TB,Used_TB,Allocated_TB,Available_TB,Committed_Percent

Hope that helps.

Andrew