[SOLVED] reporting with AWK script ?? pattern search multiple

em31amit · 06-16-2012, 06:01 AM

I have this output which is i am getting with "dmidecode" command

Code:

Handle 0x110F, DMI type 17, 34 bytes
Memory Device
	Array Handle: 0x1001
	Error Information Handle: Not Provided
	Total Width: 72 bits
	Data Width: 64 bits
	Size: No Module Installed
	Form Factor: DIMM
	Set: 16
	Locator: PROC 2 DIMM 7I
	Bank Locator: Not Specified
	Type: DDR3
	Type Detail: Synchronous
	Speed: Unknown
	Manufacturer: Not Specified
	Serial Number: Not Specified
	Asset Tag: Not Specified
	Part Number: Not Specified
	Rank: Unknown

Handle 0x1110, DMI type 17, 34 bytes
Memory Device
	Array Handle: 0x1001
	Error Information Handle: Not Provided
	Total Width: 72 bits
	Data Width: 64 bits
	Size: 4096 MB
	Form Factor: DIMM
	Set: 17
	Locator: PROC 2 DIMM 8F
	Bank Locator: Not Specified
	Type: DDR3
	Type Detail: Synchronous
	Speed: 1333 MHz
	Manufacturer: Not Specified
	Serial Number: Not Specified
	Asset Tag: Not Specified
	Part Number: Not Specified
	Rank: 1

Handle 0x1111, DMI type 17, 34 bytes
Memory Device
	Array Handle: 0x1001
	Error Information Handle: Not Provided
	Total Width: 72 bits
	Data Width: 64 bits
	Size: 8192 MB
	Form Factor: DIMM
	Set: 18
	Locator: PROC 2 DIMM 9C
	Bank Locator: Not Specified
	Type: DDR3
	Type Detail: Synchronous
	Speed: 1333 MHz
	Manufacturer: Not Specified
	Serial Number: Not Specified
	Asset Tag: Not Specified
	Part Number: Not Specified
	Rank: 2

I need to two line from this output i.e
1) Locator: PROC 2 DIMM 9C
2) Size: 8192 MB

And i want to format or report something like this.

Code:

 DIMMS               SIZE
============================
PROC 2 DIMM 9C       8192 MB

.....

I tried it with awk, but no luck.

Code:

dmidecode -t Memory |  egrep "PROC|SIZE" | awk '
/PROC/ { sub(/^.*: /,"");MEM = $0 }
/SIZE/ { sub(/^.*: /,"");SI = $0 }
/^$/ { if ( MEM ) print MEM, "\t" $0 }
'

can someone guide me, i checked for this awk on somewhere on another forum, as mentioned that it was working for them good than i modified it for my need.
http://www.linuxmisc.com/12-unix-she...fb1e5b4abb.htm

But no luck. I am Newbie in awk and i am using GNU Awk 3.1.5

AnanthaP · 06-16-2012, 08:28 AM

So wassa problem? Whats not lucky Amit?

Is the egrep failing or the awk or do you want to sort the output in descending order of size?

Can you show us the intermediate results, wrong output, error message?

OK

firstfire · 06-16-2012, 08:38 AM

Hi.

Save the following script to some file, say, `getinfo.awk', and run

Code:

dmidecode -t Memory | awk -f getinfo.awk

Code:

BEGIN{  print " DIMMS\t\tSIZE";
	for(i=0; i<30; i++) printf "=";
	print
	}
/PROC/ { sub(/^.*: /,"");MEM = $0 }
/Size/ { sub(/^.*: /,"");SI = $0 }
/^$/ { if ( MEM ) print MEM, "\t", SI }

Nominal Animal · 06-16-2012, 11:28 AM

How about

Code:

sudo dmidecode -t Memory | awk '/^[\t ]/ {
    key = tolower($0) ; sub(/^[\t ]*/, "", key) ; sub(/:.*$/, "", key) ; gsub(/[^0-9a-z]+/, "", key) ;
    val = $0 ; sub(/^[^:]*:[\t ]*/, "", val) ; list[key] = val ;
    next
}
{   if (("size" in list) && ("locator" in list))
        printf("%s\t%s\t%s\t%s %s %s %s\t%s\n", list["locator"], list["banklocator"], list["size"], list["typedetail"], list["type"], list["formfactor"], list["speed"], list["serialnumber"]) ;
    split("", list) }'

You can put it all on one long line; I added the semicolons for just that case. On my system, this outputs

Code:

DIMM0	BANK0	1024 MB	Synchronous DDR2 DIMM 400 MHz (2.5 ns)	SerNum0
DIMM1	BANK1	1024 MB	Synchronous DDR2 DIMM 400 MHz (2.5 ns)	SerNum1
DIMM2	BANK2	2048 MB	Synchronous DDR2 DIMM 400 MHz (2.5 ns)	SerNum2
DIMM3	BANK3	2048 MB	Synchronous DDR2 DIMM 400 MHz (2.5 ns)	SerNum3

em31amit · 06-17-2012, 04:55 AM

Thanks firstfire and Nominal Animal,

It works, My problem Solved.