Virtualization Articles and Resources

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Virtualization Articles and Resources

Exporting Get-NcEfficiency output to an Excel workbook

beam
NetApp
‎2012-10-31 12:10 PM

Get-NcEfficiency, released with Toolkit 2.2, provides an easy mechanism for gathering efficiency information for clustered Data ONTAP.  The Export-NcEfficiencyXls.ps1 script attached to this post exports the efficiency data from Get-NcEfficiency into an Excel workbook.

Usage:

.\Export-NcEfficiencyXls.ps1 [-WorkbookFilename <String>] [-Unit <Int64>] [-Controller <NcController>] [-Quiet]

The WorkbookFilename parameter specifies the name to give the saved Excel workbook.  If not specified, the workbook will be saved as "<controller>_nc_efficency_<timestamp>.xlsx" in the current directory.

The Unit parameter specifies the units to use when displaying values.  Possible values: 1KB, 1MB, 1GB, 1PB.  The default is 1MB.

The Controller parameter specifies the NcController object to run Get-NcEfficiency against.  If not specified, the value in $global:CurrentNcController is used.

The Quiet switch prevents the launch of Excel when the script completes.

Feel free to modify the script to meet your own needs, just be sure to share anything cool with the community!

ExportNcEfficiencyXls.zip
Reply
Was this article helpful? Yes No

Please Note:

All content posted on the NetApp Community is publicly searchable and viewable. Participation in the NetApp Community is voluntary.

In accordance with our Code of Conduct and Community Terms of Use, DO NOT post or attach the following:

  • Software files (compressed or uncompressed)
  • Files that require an End User License Agreement (EULA)
  • Confidential information
  • Personal data you do not want publicly available
  • Another’s personally identifiable information (PII)
  • Copyrighted materials without the permission of the copyright owner

Continued non-compliance may result in NetApp Community account restrictions or termination.

Replies
Craig_Mac
‎2015-02-10 11:54 PM

Hi,

 

Great report. How would I add a column to record the snap delta please?

All Community Forums
Learn about the Community Get Started
Still have Questions Start a Discussion
Rules of the Community Read More
© 2021 NetApp
Let us know
Public