Shell Programming and Scripting

Hello guys,
please help me to make simple script for parsing passwd file.
I have many passwd files from our servers, named server1.pass, server2.pass etc..
so
for server in `ls *.pass`
i need to print these rows:

server1;root:!:0:0::/root:/usr/bin/ksh
server1;user1:!:10166:10010:Admin:/home/user1:/bin/ksh
server1;user2:!:10167:10010:Admin:/home/user1:/bin/ksh
server2;user1:!:10168:10010:Admin:/home/user1:/bin/ksh
server2;user2:!:10169:10010:Admin:/home/user1:/bin/ksh
etc..
in one accounts.csv file
i have to skip all system accounts ( guess < 50 uid) but i need root account included.

Thank you very much for your help and have a nice day!!
Lukas

Code:

# awk -F: '$3>100&&$0!~/nologin/{gsub("\\..*|/.*/","",FILENAME);print FILENAME";"$0}' server?.pass > accounts.csv

if there are a lot of inputs then u can change input name as like `server[0-9]*.pass`

thank you but:
awk: syntax error near line 1
awk: illegal statement near line 1

what is your os and awk v ?

---------- Post updated at 03:19 PM ---------- Previous update was at 02:49 PM ----------

try this

Code:

# /usr/xpg4/bin/awk -F':' '$3>100&&$0!~/nologin/||$3==0{gsub("\\..*|/.*/","",FILENAME);print FILENAME";"$0}' server[0-9]*.pass

regards
ygemici

works like a charm thanks

Can i have more question to this issue please?

i modified your script to this:
/usr/xpg4/bin/awk -F':' '$3>100&&$1!~/nobody/||$3==0{gsub("\\..*|/.*/","",FILENAME);print FILENAME";"$0}' *.pass > userreport.csv

i want to keep accounts with nologin, but i want to skip some exact accounts like "nobody". How can i add more users that i want to discard.
So for example, output will be users with uid>100,uid=0, but except users (nobody,sshd and snmp).

Thank you ver ymuch for another help and have a nice day.
Lukas

you can try this

Code:

# /usr/xpg4/bin/awk -F':' '$3>100&&$1!~/nobody|sshd|snmp/||$3==0{gsub("\\..*|/.*/","",FILENAME);print FILENAME";"$0}' *.pass > userreport.csv

regards
ygemici