UNSOLVED

DanPJ

updated

13 years ago

D

DanPJ

2 Intern

•

309 Posts

2

9172

January 2nd, 2014 11:00

SPCollect to Excel

Does EMC or anyone have a utility (maybe a Powershell script) that will populate an Excel spreadsheet from an SPCollect zip file?

  • dynamox

    11 Legend

    •

    20419 Posts

    •

    87439 Points

    1624

    0

    Posted January 2nd, 2014 11:00

    instead of using USM ?

  • Storagesavvy

    474 Posts

    1624

    0

    Posted January 2nd, 2014 11:00

    Unisphere Service Manager (USM) has a feature built in to "view system configuration" and it takes an SPCollect as input and products an Excel workbook or an HTML/XML package full of very useful information.

    You can download USM from EMC Support.

  • DanPJ

    2 Intern

    •

    309 Posts

    1624

    0

    Posted January 2nd, 2014 12:00

    Shocker, the software doesn't work. Actually, I would like to do this from the CLI as this would take quite some time with the GUI. I have about 50 arrays I need to do this to.  Thanks.

    USM_Error.jpg


  • Storagesavvy

    474 Posts

    1218

    0

    Posted January 2nd, 2014 12:00

    Did you already have the SPCollect from the array and opened it? Or did you have USM go out and retrieve data.. I usually just have USM open an SPCollect I already have.

  • dynamox

    11 Legend

    •

    20419 Posts

    •

    87439 Points

    1626

    0

    Posted January 2nd, 2014 12:00

    i generate SPCollect using Unisphere, then open USM select this option

    1-2-2014 3-48-31 PM.png

  • DanPJ

    2 Intern

    •

    309 Posts

    1218

    0

    Posted January 2nd, 2014 12:00

    All done via USM.

  • Storagesavvy

    474 Posts

    1624

    0

    Posted January 2nd, 2014 12:00

    what were the last 8 characters of the spcollect file name?

  • DanPJ

    2 Intern

    •

    309 Posts

    1626

    0

    Posted January 2nd, 2014 12:00

    USM generated this:

    20140102_150836vnx_DiagnosticData_APM00125183350.zip

  • DanPJ

    2 Intern

    •

    309 Posts

    1626

    0

    Posted January 2nd, 2014 13:00

    I tested one generated from Unisphere Server (the one with "_data" in the name)and also got an error. So, no way to do this from CLI?


    USM1_Error.jpg

  • dynamox

    11 Legend

    •

    20419 Posts

    •

    87439 Points

    1218

    0

    Posted January 2nd, 2014 13:00

    using latest USM (1.3.0.1) ?

    I am not aware of any tools available to customers, partners and emc employees is probably a different story.