Shell Programming and Scripting

Hi,

I'm working with snmp, with a little script I'm able to obtain from a switch a list with a couple of values with this format

Port Mac
1 00:0A:0B:0C:0D:0E
....
(hundred of entries)


Now with a simple arp on a router I am able to obtain another list

00:0A:0B:0C:0D:0E pcname.mydomain.tld
00:0A:0B:1C:0D:0E 1.2.3.4
....
(hundred of entries, it could be a FQDN or an IP number cause not all the entries are known in DNS server)

The problem is to have a little batch script that takes the first file reads the first entry compares the MAC with all the entries in the second file and if it find a match writes the output in a third file, something like

1 00:0A:0B:0C:0D:0E pcname.mydomain.tld

if it doesn't find a match write the same the row maybe adding something like not found.

An this until all the entries in the first file are searched out.

Someone can help?

Code:

nawk '
  FNR==NR { arp[$1]=$2; next }

  { printf("%s%s%s\n", $0, OFS, ($2 in arp) ? arp[$2] : "not found") }

' FILEarp.txt FILEsnmp.txt

Post deleted - misread the question.

Thank you, very fast and useful replay, it works.

Another question, my first script (or better Ivanov script see http://groups.google.it/group/comp.d...f5ef649d853b7c) has this structure

#!/bin/sh
#
#
Mac=".1.3.6.1.2.1.17.4.3.1.1"; Port=".1.3.6.1.2.1.17.4.3.1.2"
#
Script=`basename $0`
Host=.........
Pass=........ # SNMP community name
#
GET () { snmpwalk -Onq -c $Pass -v 1$Host| $1 sed -e s/^$1\.// -e s/\"//g |
sort ;}
JOIN () { join -o 1.2,2.2,2.3,2.4,2.5,2.6,2.7 $1 $2 | sort ;}
#
for OID in Mac Port
do eval "GET \$$OID > /tmp/${Script}\$$OID" ; done

JOIN /tmp/${Script}${Port} /tmp/${Script}${Mac} | sort -nk 1,2 >> snmp.txt


How can I substitute the variable Host with a pointer to a text file with a series of host, one per line, and produce for each one of them a file maybe in /tmp in the format IPOFSWITCH.txt?

Here is one possible solution for your original post using only unix commands:

### Create matched records: in update file and also in the master file.
egrep -f upd_file master_file > matched_file

### Create not matched records: in update file and not in matched file.
egrep -v -f matched_file upd_file > tmp_not_matched_file

### Add "NOT FOUND" to the end of not matched records.
sed 's/$/NOT FOUND/' tmp_not_matched_file > not_matched_file

### Merge and sort all records into solution file.
sort matched_file not_matched_file > solution_file

I'm testing the egrep solution but I have no match. Maybe I do some errors.

This is the egrep command

egrep -f upd_file master_file > matched_file

I suppose upd_file is the one with ip port and mac, master the one with mac and name or ip.

I've tried to invert the files, for first the one with mac and name or ip but no luck, what I'm doing wrong?

Shell_Lifes solution wont work