Virtualization Articles and Resources

Exporting Get-NcEfficiency output to an Excel workbook


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.


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

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.




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

All Community Forums