Brocade SAN Health Community

Expand all | Collapse all

SANHealth report - extract to usable format?

  • 1.  SANHealth report - extract to usable format?

    Posted 01-03-2018 06:14 AM

    Hello I was curious is anyone has found a good way to extract the SAN Health report information/data into additioanl spreadsheets.


    Example:  I want to pull only the hung/stale alias/zones from these Brocade SANHealth reports ("Z_FABRIC".. tabs) to then spin cleanup scripts which I would use via command line.


    The report under Z_FABRIC.. tabs show stale aliases in aqua, attempting to past these columns to another Excel SS doesnt work effieciently b/c of the resident formatting.  I attempted multiple cut/past/copy with and without all cell fromatting options and it continually carries the source formatting or pastes ALL the data which doesnt filter the data set (stale/aqua) of which I'd like to work with.  Very same experience with text files as well, meaning all or nothing.  I know I can "ctrl" select the stale/aqua values however the efficiency decreases doing this...


    I have used zonevalidate previously, where output can be somewhat SS manipulated into scripts, just looking for the most efficient way.


    Not a huge deal but the SANHealth report is great, just wish I could further automate from its output.


    Any ideas and help would be greatly appreciated.


  • 2.  Re: SANHealth report - extract to usable format?

    Posted 02-01-2018 05:35 PM

    That's one of the reasons we added the CSV files.  They're meant to provide the data in a more "scriptable" format without having to try and slice data out of an Excel document that if formatted for readability rather than data access.