navi analyzer .csv files and excel tricks

Question

Does anyone have a standard view or template or macro they use to look at the .csv formatted output from the Navisphere Analyzer .nar files? I have a script that runs archiveretrieve.jar and archivedump.jar to produce .csv files on a daily basis. I want to pull stats for a specific host out of the csv file using Excel, and compare them day-to-day and also combine them into a new file to produce statistical running averages every day, on a cumulative basis. Before I reinvent the wheel, I thought I'd check here to see if anyone is already do this.

Thanks!

Allen Ward · Answer

I don't have anything like this, but if you DO end up 'inventing the wheel' for this, you could probably market it and save up enough for Control Center and Performance Manager (so you don't need to do this)

markgreene1 · Answer

I work for a non-profit hospital, so buying software tools to interpret the output from software tools we've already bought isn't a viable solution for me. Time to dig out the college Statistics text book I suppose.

Allen Ward · Answer

Understood. I work for a 'for profit' financial services enterprise and it is still hard to get the money we need for the tools we need.

SanSavvy · Answer

In that case I would have recommended to get hold of EMC's Visual SAN/SRM Software

Allen Ward · Answer

Oh, we have EMC Control Center now, but the fight to get it was long and hard!

Guga2 · Answer

Markgreene,You said that have a script to dump information from a NAR file to a CSV file.How do you do it?? Can you send me the syntaxe to do it.??I'm trying to do it but I can't...everytime I attempt to do it I receive this error:File 'E:\ECC\Clariion\CK200070800692
ar\08-02-2009-23-54-CK200070800692-SPB.nar' is not a valid archive file.Help me please

Guga2 · Answer

The Flare of the Storage is 03.26.080.5.020And the version of Navi CLI is 6.26.9.0.51I think that everything is OK, isn't it???

RyanP2 · Answer

Looks like those probably came out right at the same time. There is a later version of CLI out, but that probably came out with the next version of Flare.

Besides the corrupt due to ftp theory the only thing I can think of is maybe that nar is buried too far into Windows folders. If you get the same error even with that file right on C: then I don't know what is causing that error.

-Ryan

RyanP2 · Answer

I've seen that 'not a valid archive file' error when attempting to run flare 26 nar through a 24 array's analyzer (or any combination of a later nar through and earlier flare). Check the version of Flare the analyzer file came from compared to the CLI version you are running (even using ealry 26 cli with later 26 nar causes issue I bet).I don't have a script but in navi manager to dump to csv you can click tools, analyzer, archive, dump... CLI guides would have syntax depending on version of CLI.-Ryan

alokjain1 · Answer

Guga,Did this fie get ftp uploaded in 'non binary' format? that might have messed up the file.I have done nar file data extraction and not seen the error yet. If you need help with the nar file data extraction and analysis, you can contact me at alok.jain@interscapetech.com. I have built extensive tools to do nar file data analysis and provide pdf reports that shows the performance profiles and other data.

brendm · Answer

It is a very simple point, but does the script use the 'binary' command before transferring? That is what Alok is referring to and it is pivotal to the legibility of the file.

Guga2 · Answer

WillSanders Do you have a sample of a Perl script to export the NAR information to Excel?? Can you send me?? gustavo.lima@gvt.com.br

WillSanders · Answer

The scripts I have aren't specific to a host. In general I'm looking at an entire
array at this point. If you're comfortable with Perl, you can process the nar files
and export the appropriate information to Excel using the Perl module
Spreadsheet::WriteExcel. It's pretty well documented.

kelleg · Answer

Lets check to ensure that the archive file you have is a valid archive - can you open the NAR file using Navisphere GUI - Tools/Analyzer/Archive/Open?glen

CLARiiON

navi analyzer .csv files and excel tricks

Was this post helpful?