Shell Programming and Scripting

I'm looking for a script that allows me to export to CSV, the information I need. Somehow, I must gather the User ID, the User Login, the Last User Login, the Password complexity, the Password Age, The Expiration Date, . . .

My experience is equal to very, very few.

The only thing I have is this script, that I would like to improve :

"> users.csv
i=1
TMPFILE=/tmp/tmpfile
DATA=`date | awk '{print $1,$2,$3,$4}'`
cat /etc/passwd | grep -v false | grep "sh" | cut -d : -f1,5,7 > $TMPFILE
LINHAS=`cat $TMPFILE | wc -l`

while [ $i -le $LINHAS ]
do
LOGIN=`sed -n ''$i'p' $TMPFILE | cut -d: -f1`
USER=`sed -n ''$i'p' $TMPFILE | cut -d: -f2`
LASTLOGIN=`finger $LOGIN | awk '{ FILTRO = substr($0,1,4); if( FILTRO == "Last") print $3,$4,$5,$6;}'`
# if [ $LASTLOGIN -eq "" ]
# then
# LASTLOGIN=$DATA
# fi
echo "$USER;$LOGIN;$LASTLOGIN"
echo "$USER,$LOGIN,$LASTLOGIN" >> users.csv
let i=i+1
done
rm $TMPFILE

"

If someone can assist me, I'd be very pleased !

Best Regards !

For every field of your output file show us how the value can be got (file, command), this kind of data is dependant of the Unix flavour.

Your script can be simplified (KSH version):

Code:

> users.csv
while IFS=':' read login password uid gid user home shell
do
   [[ shell != *sh* ]] && continue
   lastlogin=$(finger $login | awk '/^Last/ { print $3,$4,$5,$6; }') 
   echo "$user;$login;$lastlogin"
   echo "$user;$login;$lastlogin" >> users.csv
done < /etc/passwd

Jean-Pierre.

Hi Jean-Pierre,

Thanks for shortening the script for me !

So, in order to obtain the password complexity, the age of the passwrod and the expiracy date, what do I need to include in the script ??

Please help me !

Best Regards !