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!


This NetApp Community is public and open website that is indexed by search engines such as Google. Participation in the NetApp Community is voluntary. All content posted on the NetApp Community is publicly viewable and available. This includes the rich text editor which is not encrypted for https.

In accordance to 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
  • Copyrighted materials without the permission of the copyright owner

Files and content that do not abide by the Community Terms of Use or Code of Conduct will be removed. 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?