Exporting Get-NcEfficiency output to an Excel workbook

[beam]

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!

[Craig_Mac]

Hi,

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