topic Re: Scripting Question in Operating System - HP-UX

Scripting Question

Andrew Beal — Fri, 30 May 2003 03:53:01 GMT

Hi, I have a list of names and I need to check to see if any of them exist on the unix system. There are like 200 of them, and I dont feel like using grep for each one! lol I tried writing a script to grep the names out of the passwd file, but I am not having much luck. I would appreciate it if someone could point me in the right direction as to which commands I should use, or has already got a script to perfom a similar task.

the names in the list are written in the following format.

joe bloggs
harry potter
incredible hulk
space cow

but there are like 200 of them...

Thanks in advance,

Andrew

Re: Scripting Question

Jordan Bean — Fri, 30 May 2003 04:36:06 GMT

This might get some of them...

grep -if - /etc/passwd < namelist.txt

Re: Scripting Question

Michael Tully — Fri, 30 May 2003 04:54:34 GMT

hiccup ... hiccup ...

Re: Scripting Question

Paula J Frazer-Campbell — Fri, 30 May 2003 08:58:56 GMT

Hi

Try this :-

cat /etc/passwd | sed 's/:/ /' | awk '{print $1}' | sed 's/^/ /' | sed 's/ /last /' >/tmp/name check

then diff the /tmp/namecheck against your name list.

You also might find this useful :-

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x37857d4cf554d611abdb0090277a778c,00.html

HTH

Paula

Re: Scripting Question

john korterman — Fri, 30 May 2003 09:00:30 GMT

Hi Andrew,
you could try something like this:

#!/usr/bin/sh
while read firstname lastname
do
grep -iE "${firstname}[[:space:]]*${lastname}" /etc/passwd
done <$1

run it like this:
# myscript.sh namefile

handles multiple spaces between first and second names in /etc/passwd. Names in namefile consisting of other than two names will also be processed, however literally.
If the content of your namefile causes an entry to be output more than once, then execute like this:
# myscript.sh namefile | sort -u

regards,
John K.

Re: Scripting Question

Jordan Bean — Fri, 30 May 2003 15:45:10 GMT

Oh they did go through! What's up with that? When I clicked submit, nothing happened... probably the browser. Sorry!

Re: Scripting Question

Chris Vail — Fri, 30 May 2003 15:49:18 GMT

I'd just do something like:
for NAME in `cat $MYFILE`
do
grep $NAME /etc/passwd
if test "$?" -eq "0"
then
echo $NAME>>FOUNDFILE
else
echo $NAME>>NOTFOUNDFILE
fi
done

This would give you two files, one with the names of the users that were in the password table, and another with the names that weren't.

Chris

Re: Scripting Question

Dario_1 — Fri, 30 May 2003 15:55:25 GMT

Hi Andrew:

Try this:

for NAME in `cat filewnames`
do
grep -x $NAME /etc/passwd >> output.txt
done

Make sure you create the output.txt file before executing the for i statement.

Regards,

DR

Re: Scripting Question

Leif Halvarsson_2 — Fri, 30 May 2003 16:08:51 GMT

Hi,
Have a look at the join command (man join) , it matches fields from two files .
The files must be sorted on the matching field (you have to create a temporary file for the sorted password file).

Re: Scripting Question

Leif Halvarsson_2 — Fri, 30 May 2003 16:25:24 GMT

Hi,
Simple example of the join command:
sort -t : -k 5 /etc/passwd >tmp1
sort list >tmp2
join -t : -j1 1 -j2 5 -o 1.1 tmp2 tmp1

Prints out the name from list for each matching line in passwd.