extarct command

[Deepak Seth_1]

I have properly grouped my applications under parm file. How do i use an extract command to analyse a particular application usuage over a period of time. Also how do i export it to an excel format. Any examples or links suggestions will be appreciated.

[Michael Tully]

Hi,

Have a look at the file /var/opt/perf/reptall file This is basically a template for producing reports out of measureware in asking for type of information. Below is an extract command to get the information.

In the top of the report template there some formats which tell the commands how to produce the information.
For excel, you must use 'wk1' format which is for Lotus.
Once you have transferred the information Excel will recognise this as as 1-2-3 file.

# syntax: -A Application Data
# -r report termplate file
# -xm extract by month/year
# -xp extract into file
/opt/perf/bin/extract -A -r /var/opt/perf/report_app_cpu_sum -xm 0010 -xp

For analysis of what each metrics means have a look at the HP Openview MeasureWare Agent: Dictionary of Operating System Performance Metrics book which describes each one.

The oneline version can be found here:

http://ovweb.external.hp.com/lpe/doc_serv/
--> OV Performance Agent for Unix (formerly Measureware Agent)
--> Go
--> Dictionary of Operating System Performance Metrics (6/01)

An example of a report template is attached

HTH
-Michael

[Michael Tully · Accepted solution]

Hi,

Have a look at the file /var/opt/perf/reptall file This is basically a template for producing reports out of measureware in asking for type of information. Below is an extract command to get the information.

In the top of the report template there some formats which tell the commands how to produce the information.
For excel, you must use 'wk1' format which is for Lotus.
Once you have transferred the information Excel will recognise this as as 1-2-3 file.

# syntax: -A Application Data
# -r report termplate file
# -xm extract by month/year
# -xp extract into file
/opt/perf/bin/extract -A -r /var/opt/perf/report_app_cpu_sum -xm 0010 -xp

For analysis of what each metrics means have a look at the HP Openview MeasureWare Agent: Dictionary of Operating System Performance Metrics book which describes each one.

The oneline version can be found here:

http://ovweb.external.hp.com/lpe/doc_serv/
--> OV Performance Agent for Unix (formerly Measureware Agent)
--> Go
--> Dictionary of Operating System Performance Metrics (6/01)

An example of a report template is attached

HTH
-Michael

[Wodisch]

Hello Deepak,

you can try to run "extract" interactively...

It will ask you what you want, create a text file
containing all usable metrices, give you the chance
to "vi" it (you have to remove the "*" at the beginning
of each line you are interested in), and then create
an output file. Choose the (old) Lotus 1-2-3 "WKS"
fomat, as that can be directly read by excel.

Next time you may then use the command-line approach.

HTH,
Wodisch

[Deshpande Prashant]

Hi Deepak
This is how I do it on my machine.
Copy the template file /var/opt/perf/reptall as /var/opt/perf/rept.appl
Modify as follows.
Change FORMAT ASCII to FORMAT WK1 (to get excel format output).
Only uncoment metrics parameters related to application group. (eg. starting with APP_)

Run following command to get global report related to application group.
#extract -xp -Ga -b 00:00 -e 00:00 -r /var/opt/perf/rept.appl -f

You can also generate seperate report for different shift timings by including -s 00:00-08:00 incommand to get report for time 00 to 08.

Thanks.
Prashant.