topic Re: Need to get efficiency details and autogrow details using powershell in cluster mode NetApp in Microsoft Virtualization Discussions

Need to get efficiency details and autogrow details using powershell in cluster mode NetApp

ARB — Wed, 04 Jun 2025 19:32:14 GMT

Hello All,

Need to get details of efficiency and autogrow features using powershell from multiple controller in excel sheet

sample output from cluster mode NetApp

Vserver Volume State Status Progress Policy
---------- ---------------- -------- ------------ ------------------

test test_root Enabled Idle Idle for 00:56:05 -
test2 test2_root Enabled Idle Idle for 00:56:05 -
test3 test3_root Enabled Idle Idle for 00:56:04 -

Re: Need to get efficiency details and autogrow details using powershell in cluster mode NetApp

asulliva — Sat, 13 Aug 2016 20:47:58 GMT

Hello @ARB,

Can you be more specific about what you're looking for in the output? What you've provided appears to be a truncated version of the output from "Get-NcSis" (maybe from a 7-mode system?).

Andrew

Re: Need to get efficiency details and autogrow details using powershell in cluster mode NetApp

ARB — Wed, 17 Aug 2016 03:56:38 GMT

Hello Asuvilla,

I have figured that out by checking one of your post.

current requirement is to pull all the output through powershell and generate an excel sheet and put those records in the same format without any manual intervention.

Ex:

suppose we have 15-20 fields which we are pulling and sending it to excel even if I use autosize and other format table commands it gives me an output which needs to have manual intervention in excel to do 'text to column" since I use "out-file <excel_file.xls> location.

with the above approach if there are more records using "text to column" doesn't segregate the details properly

Hence please suggest if the records can be pushed into excel without any manual intervention in the same format as it shows in the pwershell console.

NOTE: If the records are less, then "text to columns" works fine but when we have more records and try to do it using "space" as seperator then it fails

nccontroller vserver vol_name auto_grow_status auto_grow_size

Re: Need to get efficiency details and autogrow details using powershell in cluster mode NetApp

asulliva — Wed, 17 Aug 2016 13:21:54 GMT

Have you tried using the Convertto-Csv and/or Export-Csv cmdlets to get the data into something Excel can use?

Get-NcSis | Export-Csv .\temp.csv -NoTypeInformation

Andrew

Re: Need to get efficiency details and autogrow details using powershell in cluster mode NetApp

ARB — Wed, 17 Aug 2016 18:21:10 GMT

Yes . but using CSV format the output doesnt come as it shows in power shell . rather it shows the output in some weird alphanumeric values.

Moreover is there a way to convert the CSV exactly same output into an excel

Re: Need to get efficiency details and autogrow details using powershell in cluster mode NetApp

asulliva — Wed, 17 Aug 2016 20:47:07 GMT

This is because it outputs the entire object instead of just the fields which are displayed. You can force that behavior by piping to Select-Object...

Get-NcSis | Select-Object Path,State,Status,ScheduleOrPolicy,Progress | ConvertTo-Csv -NoTypeInformation

I'm not sure what you mean by your latter statement: "is there a way to convert the CSV exactly same output into an excel." Excel should handle the CSV and import the columns/rows into cells as expected.

Andrew

Re: Need to get efficiency details and autogrow details using powershell in cluster mode NetApp

ARB — Sat, 20 Aug 2016 19:25:34 GMT

Hello Asulliva,

Tried the convert-csv but doesn't yield the desired output. CSV format converts the output and same output is being imported in excel. Please see the details below.

NcController	Vserver	Name	Auto_grow_status	Max_Size(MB)	Inc_Size(MB)	Mode	Auto_Grow_Thres_Perc
------------	-------	----	----------------	------------	------------	----	--------------------
CM_Rem	test	test_root	FALSE	24	1	off	85
CM_Rem	test2	test2_root	FALSE	24	1	off	85
CM_Rem	test3	test3_root	FALSE	24	1	off	85

where as in convert-csv it shows the details as follows

"ClassId2e4f51ef21dd47e99d3c952918aff9cd","pageHeaderEntry","pageFooterEntry","autosizeInfo","shapeInfo","groupingEntry"
"033ecb2bc07a4d43b5ef94ed5a35d280",,,"Microsoft.PowerShell.Commands.Internal.Format.AutosizeInfo","Microsoft.PowerShell.Commands.Internal.Format.TableHeaderInfo",
"9e210fe47d09416682b841769c78b8a3",,,,,
"27c87ef9bbda4f709f6b4002fa4af63c",,,,,
"27c87ef9bbda4f709f6b4002fa4af63c",,,,,
"27c87ef9bbda4f709f6b4002fa4af63c",,,,,
"4ec4f0187cb04f4cb6973460dfe252df",,,,,
"cf522b78d86c486691226b40aa69e95c",,,,,

When I try to import the details in excel it comes in the same format which is pasted below