topic Re: scripting user list in Operating System - HP-UX

scripting user list

MSwift — Tue, 28 Jul 2009 16:02:09 GMT

Here is what i trying to do. First, i am trying to generate a userlist file (where i want to (logins -u) and capture only the id's which are names (we have most id's which are in the format of (2 alphabets and 4 numbers) (ex, jk4567) and we want to exclude those from the userlist file, so that we have the other id's. once the userlist file is generated, then we want to read that file and run a command $USERID so that it modifies the attributes for each id (which are NOT in jk4567) format. Could someone help with this Please?

Thanks

Mike

Re: scripting user list

Dennis Handly — Tue, 28 Jul 2009 16:11:00 GMT

Just use grep:
grep -v '^[a-zA-Z]\{2\}[0-9]\{4\}' user-list

Re: scripting user list

James R. Ferguson — Tue, 28 Jul 2009 16:13:48 GMT

Hi Mike:

One way to generate your file of ids is this way:

# perl -e 'open($fh,"-|","logins -u") or die;while (<$fh>) {@F=split;print unless $F[0]=~m{\d+}}' > /var/tmp/logins

Then you can do:

#!/usr/bin/sh
while read USERID X
do
echo ${USERID}
done < /var/tmp/logins

You could imbed the Perl snippet in your shell script too.

Regards!

...JRF...

Re: scripting user list

MSwift — Tue, 28 Jul 2009 16:32:18 GMT

JRF:

How would put all this in the same shell? Also is there a way the whole thing could be done via a shell script alone?

Thanks

Mike

Re: scripting user list

Dennis Handly — Tue, 28 Jul 2009 16:37:22 GMT

>is there a way the whole thing could be done via a shell script alone?

You don't want to use my grep or JRF's perl solution?

You can also use a real shell's pattern matching:
if [[ name != [a-zA-Z][a-zA-Z][0-9][0-9][0-9][0-9] ]]; then

Re: scripting user list

Dennis Handly — Tue, 28 Jul 2009 16:38:27 GMT

Oops, that should have been:
if [[ "$name" != [a-zA-Z][a-zA-Z][0-9][0-9][0-9][0-9] ]]; then

Re: scripting user list

James R. Ferguson — Tue, 28 Jul 2009 16:48:57 GMT

Hi (again) Mike:

> How would put all this in the same shell? Also is there a way the whole thing could be done via a shell script alone?

#!/usr/bin/sh
#!/usr/bin/sh
set -u
MYFILE=/var/tmp/mylogins
trap 'rm ${MYFILE}' EXIT
perl -e 'open($fh,"-|","logins -u") or die;
while (<$fh>) {@F=split;print unless $F[0]=~m{\d+}}' > ${MYFILE}
while read USERID X
do
echo ${USERID}
done < ${MYFILE}

...in pure Perl, I might do:

#!/usr/bin/perl
use strict;
use warnings;
my @F;
my $file = '/var/tmp/mylogins';
open(my $fh, "-|", "logins -u") or die "Can't open $file:$!\n";
while (<$fh>) {
@F=split;
system( "echo", $F[0] ) unless $F[0]=~m{\d+};
}
1;

Regards!

...JRF...

Re: scripting user list

James R. Ferguson — Tue, 28 Jul 2009 16:59:24 GMT

Hi Mike:

Here's a pure shell variation along the lines that Dennis began:

#!/usr/bin/sh
logins -u | while read USERID X
do
echo ${USERID} | grep -q -E '^[a-zA-Z]+$' && echo ${USERID}
done

Regards!

...JRF...

Re: scripting user list

MSwift — Tue, 28 Jul 2009 20:00:18 GMT

JRF:

One more question. in the script above i see 2 echo statements, i plug in the actual command instead of the second echo statement- correct?

Thanks

Mike.

Re: scripting user list

James R. Ferguson — Tue, 28 Jul 2009 20:34:00 GMT

Hi (again) Mike:

> One more question. in the script above i see 2 echo statements, i plug in the actual command instead of the second echo statement- correct?

Yes.

Given:

# echo ${USERID} | grep -q -E '^[a-zA-Z]+$' && echo ${USERID}

...we are feeding the ${USERID} value to 'grep' with the first 'echo'. If the return value from 'grep' is zero, there was a match and the second statement (another 'echo')is run. Hence, this is the one where you want to substitute the real command.

Regards!

...JRF...

Re: scripting user list

MSwift — Wed, 29 Jul 2009 13:03:34 GMT

JRF:

GM,

The script worked like a charm for all ID's except one id..the id name was dba10gaf, not sure why the script( shell version above) did not work for this ID.

Thanks

Mike

Re: scripting user list

James R. Ferguson — Wed, 29 Jul 2009 13:09:29 GMT

Hi (again) Mike:

> The script worked like a charm for all ID's except one id..the id name was dba10gaf, not sure why the script( shell version above) did not work for this ID.

If you dropped the caret (beginning-of-line) anchor, you would see this behavior:

# USERID=dba10gaf
# echo ${USERID}|grep -q -E '^[a-zA-Z]+$' && echo ${USERID}
#
# echo ${USERID}|grep -q -E '[a-zA-Z]+$' && echo ${USERID}
dba10gaf

Regards!

...JRF...

Re: scripting user list

Steven E. Protter — Wed, 29 Jul 2009 13:11:17 GMT

Shalom,

The grep statement is not picking up numbers in the id.

echo ${USERID} | grep -q -E '^[a-zA-Z]+$' && echo ${USERID}

Changes to...
echo ${USERID} | grep -q -E '^[a-zA-Z0-9]+$' && echo ${USERID}

Untested.

SEP

Re: scripting user list

James R. Ferguson — Wed, 29 Jul 2009 13:17:13 GMT

Hi:

> SEP: The grep statement is not picking up numbers in the id.

SEP, _READ_ the initial OP request again. Mike wants to EXCLUDE accounts like 'jk4567'.

...JRF...

Re: scripting user list

MSwift — Wed, 29 Jul 2009 14:06:48 GMT

so JRF,

do you recommenend to use..

echo ${USERID}|grep -q -E '[a-zA-Z]+$' && echo ${USERID}
?

Thanks

MIke

Re: scripting user list

James R. Ferguson — Wed, 29 Jul 2009 14:15:56 GMT

Hi (again) Mike:

> do you recommenend to use..

> echo ${USERID}|grep -q -E '[a-zA-Z]+$' && echo ${USERID}

No, while this will eliminate accounts like 'jk4567' it will not eliminate accounts like 'jk45lm'.

# echo ${USERID} | grep -q -E '^[a-zA-Z]+$' && echo ${USERID}

...skips both the aforementioned accounts. Isn't that what you want?

If so, notice the caret (^) to anchor the match to the beginning of the string, together with the dollar-sign ($) to anchor to the end of the string.

Regards!

...JRF...

Re: scripting user list

MSwift — Wed, 29 Jul 2009 14:30:43 GMT

JRF

You are correct about excluding jk4567. only these needs to be excluded.(2numbers4letters exact(like 2 numbers first, followed by four letters- total 6) but i still need id's like jk45lm or longer id's (than 6)dba10gaf etc. Thanks JRF, once again

Thanks

Mike

Re: scripting user list

James R. Ferguson — Wed, 29 Jul 2009 14:40:37 GMT

Hi Mike:

> You are correct about excluding jk4567. only these needs to be excluded.(2numbers4letters exact(like 2 numbers first, followed by four letters- total 6) but i still need id's like jk45lm or longer id's (than 6)dba10gaf etc.

See if this meets your needs:

# echo ${USERID} | grep -q -E '^[a-zA-Z]+[0-9]+[a-zA-Z]+$' && echo ${USERID}

Regards!

...JRF...

Re: scripting user list

MSwift — Wed, 29 Jul 2009 17:46:55 GMT

JRF

THANKS, it works

Mike

Re: scripting user list

Dennis Handly — Wed, 29 Jul 2009 20:06:51 GMT

>(2numbers4letters exact (like 2 numbers first, followed by four letters- total 6)

If you wanted exactly this, you could have used my regexp.