Summary charts report from HP Performance Manager

[liveevil]

Hi friends,

I needed generate summary report from HP Performance Manager 8.x (I don't know if it works with older version, you can try) on all nodes in node bank, 4 metrics - CPU UTIL, MEM UTIL, PAKETS IN, PAKETS OUT. Output is in one HTML file, ready for printing.

How it works:

1. with html query downloads data from HP PM to "tsv" file for a specific node

2. sends data to Excel

3. generates chart and saves it to the picture *.png (for every metric for one node - now 4, can expand)

4. generates a html chart report

Script has GUI with these functions:

- start report

- stop report (break)

- exit GUI and show html report

- counts status (bar)

- counts status of remains charts

If you need some customization then read VB Help in Excel, PerformanceManager8.1_AdminGuide.pdf (HP web).

Styles and format of a charts are manualy configured in code.

Capacity reports (forecast) not prepared yet, maybe sometimes, I'm too lazy

Requirements:

- HP Performance server as the source of a performance data, Excel

- set hostname and port for the HP PM

- text file with nodes (there are in HP PM) in one column: nodes_rpt.txt

In the code are some czech notes, it's only for debug, can translate via google but the same notes are in English at the status on GUI 8).

Sorry for my english and Happy reports!

Edited August 31, 2010 by liveevil

[liveevil]

Hi again,

I prepared some pictures for your better illustration. See the Attachments.

When you start the script:

When you Run report:

When you stoped running:

When the report finished after stopping:

liveevil

[justauser]

Hi friends,

I needed generate summary report from HP Performance Manager 8.x (I don't know if it works with older version, you can try) on all nodes in node bank, 4 metrics - CPU UTIL, MEM UTIL, PAKETS IN, PAKETS OUT. Output is in one HTML file, ready for printing.

How it works:

1. with html query downloads data from HP PM to "tsv" file for a specific node

2. sends data to Excel

3. generates chart and saves it to the picture *.png (for every metric for one node - now 4, can expand)

4. generates a html chart report

Script has GUI with these functions:

- start report

- stop report (break)

- exit GUI and show html report

- counts status (bar)

- counts status of remains charts

If you need some customization then read VB Help in Excel, PerformanceManager8.1_AdminGuide.pdf (HP web).

Styles and format of a charts are manualy configured in code.

Capacity reports (forecast) not prepared yet, maybe sometimes, I'm too lazy

Requirements:

- HP Performance server as the source of a performance data, Excel

- set hostname and port for the HP PM

- text file with nodes (there are in HP PM) in one column: nodes_rpt.txt

In the code are some czech notes, it's only for debug, can translate via google but the same notes are in English at the status on GUI 8).

Sorry for my english and Happy reports!

I realise it's been a while but I'll ask anyway.

Any chance you'd be able to attach the code here, I need to pull out some data repeatedly out of HP PM and can't find any examples.

Much appreciated

[BrewManNH]

I realise it's been a while but I'll ask anyway.

Any chance you'd be able to attach the code here, I need to pull out some data repeatedly out of HP PM and can't find any examples.

Much appreciated

liveevil hasn't been back since November of 2010, I don't think you'll see much from him/her. Better to open a new thread explaining what you need, what you've tried, and what's not working for you.