UNIX for Dummies Questions & Answers

STMC429 (192.168.171.72)
2008-11-24 14:18:09.412 softwareupdate[11853] Loading CatalogURL http://creativesus.conair.lan:8088/index.sucatalog
No new software available.
There are no updates to install


STMC444 (3) (192.168.171.116)
2008-11-24 14:14:31.771 softwareupdate[3473] Loading CatalogURL http://creativesus.conair.lan:8088/index.sucatalog
There are 1 updates to install


STMC604 (192.168.171.48)
2008-11-24 14:13:44.486 softwareupdate[4239] Loading CatalogURL http://creativesus.conair.lan:8088/index.sucatalog
There are 1 updates to install


STMC606 (192.168.171.113)
There are 2 updates to install


STMC607 (192.168.23.54)
2008-11-24 14:13:44.457 softwareupdate[4854] Loading CatalogURL http://creativesus.conair.lan:8088/index.sucatalog
There are 1 updates to install

I only want the STMC#
and the amount of updates available
if no updates, that machine can be skipped
---------------------------------------------------------------------------------------------------------------

Output Should look like:
STMC607 1

Extra points for explanation


Thanks!

Something like this?

Code:

awk '/STMC/{m=$1} m && /^There/ && int($3)>0 {print m, $3}' file

Pretty awesome Franklin.. care to explain it?

Sure, here we go:

Code:

awk '/STMC/{m=$1} m && /^There/ && int($3)>0 {print m, $3}' file

Code:

/STMC/{m=$1}

Store the value of the 1st field (STMCxxx) in the variable m if the line begins with STMC.

Code:

m && /^There/ && int($3)>0 {print m, $3}

If m is set and the line begins with There and the 3th field is an integer, print the variable m and the value of the 3th field.

Regards

Brilliant, I need to learn AWK!!!