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"

thanks - I will try that now

what does the  '-join' do?

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

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

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

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

this is how the output should look like.

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?

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

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?  

"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

why is this not working:

$aggr = Get-NaAggrSpace

$aggr.SizeFree

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

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

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-...

yeah

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