topic Re: Turn a report into one line per record with awk ? in Operating System - Linux

Turn a report into one line per record with awk ?

Stuart Abramson — Fri, 19 Aug 2005 14:44:23 GMT

I would like some awk help.

This is the output from syminq -clar -v. It produces some 15 lines for every LUN presented to this server:

Device Physical Name : /dev/rdsk/c101t5d3
Device Serial ID : Ch2 CONT

Vendor ID : DGC
Product ID : CX700WDR5
Product Revision : HP03

Peripheral Device Type : Direct Access

Controller Number : 65
Target ID : 5
Logical Unit Number : 3

Capacity (in KB) : 8838720

Clariion ID : APM00052802175
Device Clariion Name : 0117

Device State : ASSIGNED
Device WWN : 60:06:01:60:90:84:15:00:5C:B1:65:C1:AC:10:DA:11

Powerpath Device Type : CHILD

VxVM DMP Device Type : N/A

Device Physical Name : /dev/rdsk/c101t5d4
Device Serial ID : Ch2 CONT

Vendor ID : DGC
Product ID : CX700WDR5
Product Revision : HP03

Peripheral Device Type : Direct Access

Controller Number : 65
Target ID : 5
Logical Unit Number : 4

Capacity (in KB) : 70709760

Clariion ID : APM00052802175
Device Clariion Name : 0116

Device State : ASSIGNED
Device WWN : 60:06:01:60:90:84:15:00:FC:B4:A8:13:AC:10:DA:11

Powerpath Device Type : CHILD

VxVM DMP Device Type : N/A

I would like to turn this into one line per LUN, like this:

Dev Type GB Array LuN
c101t5d3 CX700WDR5 7079760 APM..2175 0116

But I cant' figure out how to do it.

I tried:

awk '{RS="Device Physical Name"; print $3, $9...}'

but it's not working..

Re: Turn a report into one line per record with awk ?

RAC_1 — Fri, 19 Aug 2005 14:57:29 GMT

Re: Turn a report into one line per record with awk ?

Marlou Everson — Fri, 19 Aug 2005 18:15:47 GMT

Save the desired info in a variable and print it out at the end. For example,

awk '{/Device Phy/ {ctd=$5;next}
/Product ID/ {prodid=$4;next}
/Capacity/ {kb=$5;next}
/VxVM/ {print ctd, prodid, kb/1000}'

I'm guessing the fields.

Marlou

Re: Turn a report into one line per record with awk ?

Hein van den Heuvel — Fri, 19 Aug 2005 23:13:13 GMT

Marlou outlines the classic and recommended solution, specially if you are goinf to be selecting specific fields, adn possibly re-ordering the output.

Now if the problem is simple "I would like to turn this into one line per LUN" then the answer would be:

awk -F" : " '{if (NF>1){ line = line " " $2}}/^VxVM/{print line; line = ""}' x

. make " : " the field seperator.
. if more than 1 field in the input then add field 2 to variable 'line'.
. if input starts with VxVM then print the line variable and clear it.

Hein.

Re: Turn a report into one line per record with awk ?

Victor Fridyev — Sat, 20 Aug 2005 09:43:24 GMT

Hi,

If the string with VxVM DMP Device Type is the last in the output, try this:
awk 'NF<2{next}
/VxVM DMP Device Type/ {print $NF;next}
{printf("%s ",$NF}'

HTH

Re: Turn a report into one line per record with awk ?

Stuart Abramson — Mon, 22 Aug 2005 10:35:29 GMT

all good answers. Thanks.