topic Re: Get-NaAggrSpace in Microsoft Virtualization Discussions

Get-NaAggrSpace

JSHACHER11 — Thu, 05 Jun 2025 05:39:10 GMT

Hi guys,

I am trying to export to CSV a list/table of Aggregate space stats. This isn't working:

================================================

$aggr = Get-NaAggrSpace

$customobject = new-object psobject

add-member -inputobject $customobject -membertype noteproperty -name Aggregate -value $aggr.AggregateName

add-member -inputobject $customobject -membertype noteproperty -name Free_Size -value $aggr.SizeFree

add-member -inputobject $customobject -membertype noteproperty -name Snapshots_Use -value $aggr.SizeSnapUsed

add-member -inputobject $customobject -membertype noteproperty -name Used -value $aggr.SizeUsed

add-member -inputobject $customobject -membertype noteproperty -name Volumes_Use -value $aggr.SizeVolumeUsed

add-member -inputobject $customobject -membertype noteproperty -name Volumes -value $aggr.Volumes

$customobject | export-csv c:\aggr_size.csv -notypeinformation

===============================================

what would be the best way? I would also like to export it in different units (MB, GB,..)

Thank you

Joel

Re: Get-NaAggrSpace

vinith — Tue, 01 Apr 2014 08:04:50 GMT

This should work for you

Get-NaAggrSpace | select AggregateName,@{l='SizeFree(GB)';e={([math]::Round([decimal]($_.SizeFree)/1gb,2))}},@{l='SizeSnapUsed(GB)';e={([math]::Round([decimal]($_.SizeSnapUsed)/1gb,2))}},@{l='SizeUsed(GB)';e={([math]::Round([decimal]($_.SizeUsed)/1gb,2))}},@{l='SizeVolumeUsed(GB)';e={([math]::Round([decimal]($_.SizeVolumeUsed)/1gb,2))}},@{label="Volumes";expression={$_.volumes -join ","}} | Export-Csv "c:\vins.csv"

Re: Get-NaAggrSpace

JSHACHER11 — Tue, 01 Apr 2014 08:10:22 GMT

thanks - I will try that now

what does the '-join' do?

Re: Get-NaAggrSpace

JSHACHER11 — Tue, 01 Apr 2014 08:13:41 GMT

is there an easy way to change the size from GB units to MB globally?

Re: Get-NaAggrSpace

vinith — Tue, 01 Apr 2014 08:18:41 GMT

you can just replace 'gb' with 'mb' in above code to get your output in mb. check this technet link http://technet.microsoft.com/en-us/library/ee692684.aspx

Re: Get-NaAggrSpace

vinith — Tue, 01 Apr 2014 08:20:30 GMT

The join operator concatenates a set of strings into a single string., for mode details check out

PS C:\Users\vinith> Get-Help about_join

Re: Get-NaAggrSpace

JSHACHER11 — Tue, 01 Apr 2014 08:23:23 GMT

the output isn't working. I am getting rows instead of columns in the CSV file

Re: Get-NaAggrSpace

vinith — Tue, 01 Apr 2014 08:28:27 GMT

this is how the output should look like.

Re: Get-NaAggrSpace

JSHACHER11 — Tue, 01 Apr 2014 08:29:02 GMT

this is what I am getting - I need a list of volumes in a column, not a row - is that possible? I guess we need to create a file for each aggregate?

AggregateName

SizeFree(GB)

SizeSnapUsed(GB)

SizeUsed(GB)

SizeVolumeUsed(GB)

Volumes

aggr0 2GB 1GB 1GB 1GB vol0, vol1, vol2, vol3, vol4,....

Re: Get-NaAggrSpace

JGPSHNTAP — Tue, 01 Apr 2014 12:07:26 GMT

Joel -

Your first example isn't going to work because you don't loop through the array. Also, you don't really need to create custom objects in this example b/c they are already created

Why do you need a list of volumes in a row?

Re: Get-NaAggrSpace

JSHACHER11 — Tue, 01 Apr 2014 12:11:09 GMT

"Why do you need a list of volumes in a row?"

easy to read

I can have the list of volumes in a separated list though

Re: Get-NaAggrSpace

JSHACHER11 — Tue, 01 Apr 2014 12:20:37 GMT

why is this not working:

$aggr = Get-NaAggrSpace

$aggr.SizeFree

Re: Get-NaAggrSpace

JGPSHNTAP — Tue, 01 Apr 2014 12:26:59 GMT

Joel - do a search for an excel report I wrote that will give you a dashboard, Try that out and see if thats what you need

Re: Get-NaAggrSpace

JGPSHNTAP — Tue, 01 Apr 2014 12:30:02 GMT

Joel -

Slow down a little ...

It's not working because it's an array of objects. That's why. I know your just getting started with PS, you need to read up on it a little. Can't all be trial by fire

Re: Get-NaAggrSpace

JSHACHER11 — Tue, 01 Apr 2014 12:30:33 GMT

the one with the traffic lights?

https://communities.netapp.com/community/netapp-blogs/netapp-blog-archive/product-and-solutions-blog-archive/blog/2013/02/01/detailed-report-on-filer-aggr-and-volumes-and-save-to-excel-and-htm

Re: Get-NaAggrSpace

JGPSHNTAP — Tue, 01 Apr 2014 12:36:03 GMT

yeah

Re: Get-NaAggrSpace

JSHACHER11 — Tue, 01 Apr 2014 12:39:57 GMT

that was last year and in there you stated that "I'm in no way a powershell expert" - I can tell you that it's not true anymore

thanks for the help