topic Re: help in script in Operating System - HP-UX

help in script

Jairo Campana — Mon, 18 Apr 2005 15:28:55 GMT

I need execute this line and not work:
(this not response)
rsh 172.31.199.48 grep IITT@speedy.com.ar /opt/SUNWmsgsr/log/mail.log_current|grep EA |awk '{print $12}' |sort|uniq

========================================
(using ' ' )
rsh 172.31.199.48 grep 'IITT@speedy.com.ar /opt/SUNWmsgsr/log/mail.log_current|grep EA |awk '{print $12}' |sort|uniq'
awk: syntax error near line 1
awk: illegal statement near line 1

thanks

Re: help in script

Steve McKenna_3 — Mon, 18 Apr 2005 15:38:16 GMT

I'm guessing that you mean remsh or rexec (for remote commands) rather than rsh (restricted shell).

What O/S version is the server at 172.31.199.48? And what O/S are you running from?

...Steve...

Re: help in script

Steve McKenna_3 — Mon, 18 Apr 2005 15:40:05 GMT

A thought... maybe it's getting crossed up by the single quotes on the whole phrase and the single quotes for the awk? What if you use double quotes for the outside?

Re: help in script

Steve McKenna_3 — Mon, 18 Apr 2005 15:43:02 GMT

p.s. sort -u will eliminate one nesting level as well...

Re: help in script

RAC_1 — Mon, 18 Apr 2005 15:48:18 GMT

grep 'IITT@speedy.com.ar /opt/SUNWmsgsr/log/mail.log_current|grep EA |awk '{print \$12}' |sort|uniq'

Escape $12 - \$12. also sort -u is enough.

Re: help in script

Rick Garland — Mon, 18 Apr 2005 15:48:52 GMT

When you grep for EA, are there 12 fields to awk from?

Also remember to use the shift function if you are looking for over $9 items.

With the sort command you can include the -u as this is the unique flag to sort.

Re: help in script

Jairo Campana — Mon, 18 Apr 2005 15:51:40 GMT

steve:
double quotes for the outside not work

Re: help in script

Steve McKenna_3 — Mon, 18 Apr 2005 15:52:09 GMT

awk lets you address $12 directly. In the test I ran on 11i, if you try to address $12 and there is none, no error is generated, just null output.

Re: help in script

Steve McKenna_3 — Mon, 18 Apr 2005 15:54:21 GMT

I'm looking at your command again.. just saw something...

in the second example, shouldn't it be 'grep ~ rather than grep 'IITT~ ?

Re: help in script

Jairo Campana — Mon, 18 Apr 2005 16:05:52 GMT

when execute the command in the server locally without rsh its work!!!
using $12 of awk

server locally:
##grep IITT@speedy.com.ar /opt/SUNWmsgsr/log/mail.log_current |grep " EA "|awk '{print $12}'|sort -u
output:
blinker@binker.com

its work

the problem is when use rsh

Re: help in script

Jairo Campana — Mon, 18 Apr 2005 16:11:08 GMT

steve :using 'grep ~ not work

rsh 172.31.199.48 'grep IIT@speedy.com.a/opt/SUNWmsgsr/log/mail.log_current |grep " EA "|awk '{print $12}'|sort -u'

Re: help in script

Jairo Campana — Mon, 18 Apr 2005 16:11:57 GMT

steve using : 'grep~
rsh 172.31.199.48 'grep IITT@speedy.com.a/opt/SUNWmsgsr/log/mail.log_current |grep " EA "|awk '{print $12}'|sort -u'
awk: syntax error near line 1
awk: illegal statement near line 1

Re: help in script

Jim Butler — Mon, 18 Apr 2005 16:42:22 GMT

write a script to rsh with called "doit"

on the first line, specify your shell (in the shebang line)

i.e.

#/bin/sh

grep `IITT@speedy.com.ar /opt/SUNWmsgsr/log/mail.log_current|grep EA |/bin/awk '{print $12}' |sort|uniq `

Note the changes in the first and last quote that I made -

anyway - chmod doit to 755 and place it on an accessible automount point, or... place it on the system.

then

rsh 172.31.199.48 -n /path_to/doit

good luck

Re: help in script

Jim Butler — Mon, 18 Apr 2005 16:46:34 GMT

rsh 172.31.199.48 -n `grep "IITT@speedy.com.ar" /opt/SUNWmsgsr/log/mail.log_current | grep EA |awk '{print $12}' |sort|uniq `

If you want to use the rsh without "doit"

surround the execute string in the single tic's (the ~` key) and let her rip - that should work for you.

Re: help in script

Jairo Campana — Tue, 19 Apr 2005 08:09:50 GMT

doit no work
my log contains these data:
I need to obtain the field awk $12.

can replace "awk" by another command?

log:

19-Apr-2005 01:50:57.63 4b6f.1e14.25248 tcp_auth tcp_local EA 130 IITT@speedy.com.ar rfc822;IITT@speedy.com.ar IITT@speedy.com.ar <0IF600ECPG4IWF90@tdimso48.backend.tdata.com.ar> *IITT@speedy.com.ar

I need the field *IITT@speedy.com.ar

Re: help in script

Jairo Campana — Tue, 19 Apr 2005 08:29:46 GMT

this works but the answer is very slow:
rsh 10.1.1.10 -n grep IITT@speedy.com.ar /opt/SUNWmsgsr/log/mail.log_current |grep " EA "|awk '{print $14}'|sort -u

without command |sort -u
rsh 10.1.1.10 grep IITT@speedy.com.ar /opt/SUNWmsgsr/log/mail.log_current |grep " EA "|awk '{print $12}'

this works, and the answer is very fast but the result is:
*IITT@speedy.com.ar
*IITT@speedy.com.ar
*IITT@speedy.com.ar
.
.

that I can do
thanks

Re: help in script

Jairo Campana — Tue, 19 Apr 2005 13:55:06 GMT

thanks, solved:
this works but the answer is very slow:
rsh 10.1.1.10 -n grep IITT@speedy.com.ar /opt/SUNWmsgsr/log/mail.log_current |grep " EA "|awk '{print $12}'|sort -u

the filed $awk is $12