UNSOLVED
M
markgreene1
5 Posts
0
2748
March 28th, 2007 12:00
navi analyzer .csv files and excel tricks
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!
Thanks!
821
0
Posted March 29th, 2007 06:00
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.821
0
Posted March 29th, 2007 07:00
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.821
0
Posted March 29th, 2007 20:00
In that case I would have recommended to get hold of EMC's Visual SAN/SRM Software821
0
Posted March 30th, 2007 10:00
Oh, we have EMC Control Center now, but the fight to get it was long and hard!821
0
Posted August 3rd, 2009 12:00
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\nar\08-02-2009-23-54-CK200070800692-SPB.nar" is not a valid archive file.
Help me please821
0
Posted August 3rd, 2009 13:00
The Flare of the Storage is 03.26.080.5.020
And the version of Navi CLI is 6.26.9.0.51
I think that everything is OK, isn't it???148
0
Posted August 3rd, 2009 13:00
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.
-Ryan821
0
Posted August 3rd, 2009 13:00
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.
-Ryan821
0
Posted August 3rd, 2009 13:00
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.
Allen Ward
6 Operator
•
2124 Posts
821
0
Posted March 28th, 2007 13:00