Tag Archives: Script

Converting SPcollect files into XLS

javascript on the CLI

Converting SPCollect files into XLS or “How to run javascript on the command line”

Converting EMC SPcollect files into a readable Excel spreadsheet can be done by a js script named “ArrayConfigToXLS.js”. When you install USM (Unisphere Service Manager) a folder called C:\EMC will be created (or on another location since you can specify where this will be created). In that folder a sub-folder called “repository” exists and one of the files you’ll find there is “ArrayConfigToXLS.js”.

Take one of the two SPcollect files (Clariion or VNX), open the zip file and look for the file CKM[serial]SP[A_or_B]_[date]_[time]_[some_number]_sus.zip and open that zip file. Look for the file called “SPA_arrayconfig.xml”; sort on extension and pick that xml, that’s easier, since it will be the only xml there.

Copy that xml to c:\EMC\repository, open a CLI (e.g. CMD.exe) and type:

cscript ArrayConfigToXLS.js SPA_arrayconfig.xml SPA_arrayconfig.xls

The “script” will allow you to run the “js” script and the outcome is that an XLS will be created. Now open the XLS in your favorite spreadsheet application and you’ll find the configuration of your EMC array!