cpu utilization average for a month...

[Dan Copeland]

Admins,

Can you extract data from measureware collected data, via the command line or another manner to hit the data files? I want to be able to grab cpu util for a large number of servers over a months time and dump it into a spreadsheet. Don't want to have to run sar on each box.

tia,
Frank

[Sridhar Bhaskarla]

Hi Frank,

Look at "extract" command. You can use this to extract data from the data files.

Run extract and select "guide" option. It will take you through step by step process.

It will open a report file where you have to uncomment the lines that you want the report on. Also look at /opt/per/paperdocs/mwa/C directory for more documentation apart from the man page of "extract".

-Sri

[Patrick Wallek]

Yes you can extract measureware data from the command line.

You use the 'extract' command.

If you do:

# extract

You will come to the

extract > Enter command:

prompt. At that point you can type 'guide' and you will go through a series of prompts to help extract the data you require. It will allow you to save the data to a file and you can then uload that file to your PC and import the data into Excel, or your spreadsheet of choice.

[Robert Thorneycroft]

Full details of how to use MWA extract, and anything else to do with Measureware for that point can be found at:
http://ovweb.external.hp.com/ovnsmdps/pdf/mwausers.pdf

Hope this helps,

Kind regards,

Robert Thorneycroft

[Steven Gillard_2 · Accepted solution]

Yes, using the extract command, as follows:

1) Create a 'report' file containting the following lines:

DATA TYPE GLOBAL
DATE
TIME
GBL_CPU_TOTAL_UTIL

2) Run extract:

$ extract -xp -g -l /var/opt/perf/datafiles/logglob -r report -b today -f outfile

That will give you the 5 minute CPU utilisation data for today. You can change the interval by specifying different -b and -e options, see the man page for details. If you need other metrics, take a look at the /var/opt/perf/reptall file for a list.

Regards,
Steve

[Brian M Rawlings]

Frank: the companion product for Measureware is Perfview (which has been recently renamed by HP in their ongoing efforts toward total obfuscation).

The new name is "Openview Performance Manager", after months of deliberation by the "Really Cool and Inovative Product Name Department.

Perf View/OPM is the data extract tool that you buy ONE of, to extract data from MWA files on any and all of your servers/systems. It lets you select the data type and time frame for the report, and makes cute little graphs and so forth.

As Patrick says, you can use 'extract' (for free), and ftp the extracted file to a PC for import into excel, which works pretty good and lets you make cute little graphs.

If you want support from HP, though, you could buy their extract/filter/display product, which is somewhat easier to use than extract. I tend to prefer to automate this, which means scripting, which means using extract.

Hope this gives you some context.

--bmr

[Dan Copeland]

thank's for all the suggestions...extract looks to be perfect for the job.