HP Config Collector and XML files (HPCC)

[Albatross]

Hi Folks,

I've installed the latest HPCC for SAN Environments, and the tool successfully generated an XML file. I've read in the forums that it is possible to format the data into a more usable format, but I have no idea of the tools involved.

This would be a great aid in documenting, change control, planning before upgrades and such tasks.

Please, may you shed some insight into this topic?

Thanks a lot,

Albatross

[Roy Main]

Perhaps there is a style sheet for it in the tool? I'm not familiar with it.

Can you post your xml file?

[Albatross]

Hi Roy,

The file is attached, thanks,

A

[Roy Main]

And what are the important pieces of data you want to see? I'm assuming you're interested in a summary of this info?

[Albatross]

Hi Roy,

It would be great if the data could be stripped into different sections for each main subsystem, such as:

- Array
- Hosts
- Virtual Disks
- Presentations

Each section with a simple table containing the data.

Thanks for all your comments,

A.

[Albatross]

Hey Roy,

Really nice job there!

As you may know, in EVA environments it's really useful to have a quick overview of the following:

A. Physical (Hardware) Level:
- Controllers (Firmware, WWN, Versions)
- Enclosures (firmware, versions)
- Physical Disks (firmware, bay)

B. Logical (Configuration):
- DiskGroups (name, spare policy, used and available space)
- Virtual Disks (name, size, VRAID level, presentation to hosts, LUN assigned)

Your XML skills are really cool man, thanks a lot!

Albatross

[Roy Main]

Hey Albatross,

Sorry, I forgot to say I really don't know EVA. LOL.

That's why I need plenty of guidance on what should be displayed. I'll see if I can go through and differentiate the pieces that you have outlined.

:-)

[Roy Main]

Ok, what does the 'enclosure' equate to in the report?

Is that what the report is calling the 'cabinet'?

thanks!

[Albatross]

Hi Roy,

I think the "objecttype" of a disk enclosure is called "diskshelf" in the report. These things have 14 bays to accommodate hard drives.

The hard drives are then grouped into DiskGroups (objectype=diskgroup) by the controller .

The disk space from the DiskGroups is then divided into individual Virtual Disks (objectype=virtualdisk).

The virtual disks are then presented (objecttype=presentedunit) to different servers (ot=host) to be recognized, formatted and used by the operating systems.

Hope it was somewhat clear, thanks for your help!

A.

[Roy Main]

Here's an updated stylesheet. You can see the data is flat as opposed to being sorted hiearchically. This can probably be done if I studied the source document more.

Do you use the SAN Xpert tool? I understand it can take your report and represent your EVA graphically. Is there something the SAN xpert tool is lacking or not useful for your environment?

Btw, the stylesheet can be further tweaked if you'll let me know what you would like to add/subtract.

Regards,
roy

[Rob Leadbeater]

Hi,

Most of the useful tools to analyse the XML files are internal HP tools, and not publically available.

Navigator is one, which is very useful, as it also allows analysis of controller event logs etc. however you're unlikely to find a copy for download anywhere :-(

Cheers,

Rob

[khoogcw]

superb xml style sheet, is just so useful for a beginner in EVA like myself.

can someone clarify the collection for decimals?

for example in the output xml from HPCC, I see the following:
"16491.94"

however with the xslt provided in this thread, usedstoragespace is reported as
"usedstoragespace 24095621120"

I tried to play around with the style sheet but nothing seems to work.

Roy/Albatross any ideas?

Thanks in advance.

Winston

[Roy Main]

I think the xsl is just providing an overview. The field, 'usedstoragespace' appears more than once in the report. So what's happening is that only one occurrence of 'usedstoragespace' is getting displayed according to the hiearchy I designated as an 'overview'.

I hope that makes sense. :-) At least I believe that's what is occurring. I did that stylesheet last year. Can you upload your report?

[Marcus Schack]

Hello Rob, you might find someone from your local HP Team who will run the XML files through SANXpert. Sometimes if you have 24hour support, the people who look after that support will do that for you. There are two no tools to look at. SAN Designer and SAN Visibility, here is the URL...

http://h18006.www1.hp.com/storage/networking/sansolutions.html

[khoogcw]

Hi all,

Thanks for your reply on this but I cant share the xml, company policy :(

I managed to extract the data I require but for the nested loops, something is wrong. My "hostname","lunnumber" and "hostosmode_0" are going to the next line when printed. I do not want this and want to have a single row starting with the vdisk name.

Any ideas?

[Roy Main]

You just need to remove the tags in the second xsl:for-each loop.

[khoogcw]

Hi,

Yes that works but it doesn't give me the formatting I need.

After some research (I sux big time in programming stuff), managed to get what I need with the following :)

May not be optimal but its works for me :P

Thanks for all who replied.