topic Re: cpu utilization average for a month... in Operating System - HP-UX

cpu utilization average for a month...

Dan Copeland — Fri, 03 Jan 2003 15:36:33 GMT

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

Re: cpu utilization average for a month...

Sridhar Bhaskarla — Fri, 03 Jan 2003 15:49:02 GMT

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

Re: cpu utilization average for a month...

Patrick Wallek — Fri, 03 Jan 2003 15:49:33 GMT

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.

Re: cpu utilization average for a month...

Robert Thorneycroft — Fri, 03 Jan 2003 15:53:34 GMT

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

Re: cpu utilization average for a month...

Steven Gillard_2 — Fri, 03 Jan 2003 15:55:50 GMT

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

Re: cpu utilization average for a month...

Brian M Rawlings — Fri, 03 Jan 2003 16:01:15 GMT

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

Re: cpu utilization average for a month...

Dan Copeland — Fri, 03 Jan 2003 16:41:42 GMT

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