Sponsored Content
Full Discussion: awk not working correctly
Top Forums Shell Programming and Scripting awk not working correctly Post 302728571 by Junes on Thursday 8th of November 2012 05:56:26 AM
Old 11-08-2012
I have tried it and here is the following message i get, which still not working..

I am expecting 18 rows not 0

The lastfailed bit is not working..


Script


Code:
LASTFAILEDJOB=/usr/openv/netbackup/scripts/GB-LDN/Junaid/temp_files/lastfailedjob
#

cat $LASTFAILEDJOB

RUN=`sudo $ADM_CMD/bpdbjobs -most_columns | grep -i LDN_ | awk -F, 'NR==FNR { $LASTFAILEDJOB=$1; next } /[lL][dD][nN]_/ && ($1>$LASTFAILEDJOB)&&(($4=="150")||($4=="156")) { print $8 }'| wc -l `


Script Output
Code:
+ cat /usr/openv/netbackup/scripts/GB-LDN/Junaid/temp_files/lastfailedjob
237308642
+ sudo /usr/openv/netbackup/bin/admincmd/bpdbjobs -most_columns
+ grep -i LDN_
+ wc -l
+ awk -F, NR='=FNR { $LASTFAILEDJOB=$1; next } /[lL][dD][nN]_/ && ($1>$LASTFAILEDJOB)&&(($4=="150")||($4=="156")) { print $8 }'
+ RUN=0


Output i am expecting - 18 rows
Code:
237322668 156 CAM_NT_PRD_SQL sv157594.xx.com nmegbp61xxcom W_NMEGBP61_VTL11
237322411 156 CAM_NT_PRD_SQL sv157594.xx.com nmegbp61xxcom W_NMEGBP61_VTL11
237322357 156 CAM_NT_PRD_SQL sv157594.xx.com nmegbp61xxcom W_NMEGBP61_VTL11
237322356 156 WAT_NT_PRD sv077839.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237322217 156 CAM_NT_PRD_SQL sv157594.xx.com nmegbp61xxcom W_NMEGBP61_VTL11
237321586 156 CAM_NT_PRD_SQL sv157594.xx.com nmegbp61xxcom W_NMEGBP61_VTL11
237320477 156 WAT_NT_PRD sv077900.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237320253 156 WAT_NT_PRD sv077839.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237320222 156 WAT_NT_PRD sv077900.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237318659 150 WAT_NT_PRD_SQL sv160720.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237316578 150 WAT_NT_PRD_SQL sv160720.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237315203 150 WAT_NT_PRD_SQL sv160720.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237315129 150 WAT_NT_PRD_SQL_LRG sv191260.xx.com ln2p1001infxxcom ln2p1001inf-hcart3-robot-acs-24
237312932 150 WAT_NT_PRD_SQL sv160720.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237312070 150 WAT_NT_PRD_SQL sv160720.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237309124 150 WAT_NT_PRD_SQL sv160720.xx.com nmegbp11.ipe.commerzbank.com C_NMEGBP11_VTL61
237308801 156 WAT_NT_PRD_SQL_LRG sv180411.xx.com ln2p1001infxxcom ln2p1001inf-hcart3-robot-acs-24
237308645 156 WAT_NT_PRD_SQL_LRG sv191260.xx.com ln2p1001infxxcom ln2p1001inf-hcart3-robot-acs-24

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Script not working correctly

I have a simple script that I want to run every 30 minutes but only when I execute it. I don't want it to be a crontab job. so i have for example date ls -l who sleep 1800 The first time it executes correctly but after the first time it nevers execute back again. It should execute after... (2 Replies)
Discussion started by: elchalateco
2 Replies

2. Shell Programming and Scripting

if not working correctly

Anyone have an idea why this if statement does not work correctly? "test2.sh" 18 lines, 386 characters #!/usr/bin/sh WARNING=80 CRITICAL=95 check_it() { if ] || ];then echo "YES ] || ]" else echo "NO ] || ]" fi } check_it 80.1 check_it 81.1 (3 Replies)
Discussion started by: 2dumb
3 Replies

3. Shell Programming and Scripting

Variable not working correctly.

Hi, I have a script where I am trying to set a local variable using the following, MYVAR="$NAME"_"$NAME2".txt where say, NAME = one NAME2 = two so I want the output one_two.txt but what I am getting is, two.txt basically the $NAME2 is overwriting, what am I doing wrong? ... (3 Replies)
Discussion started by: walsh_j
3 Replies

4. Programming

Shell Implementation not working correctly

//save in/out int tmpin = dup(0); int tmpout = dup(1); //set initial input int fdin; if(_inputFile) { fdin = open(_inputFile, O_RDONLY | O_CREAT, S_IREAD | S_IWRITE); } else { //use default input fdin = dup(tmpin); } int ret; int fdout; for(int i = 0; i... (14 Replies)
Discussion started by: AirBronto
14 Replies

5. UNIX for Dummies Questions & Answers

grep -A switch not working correctly with -m

egrep -A 7 -m 2 -h 'Date:|Time:' *.html this is showing only 2 line after the context of the 2nd found match. Is this a bug in grep? egrep -A 7 -m 2 -h 'Time:' *.html - this works correctly (2 Replies)
Discussion started by: zer0
2 Replies

6. Shell Programming and Scripting

Find cmd not working correctly in script

I am trying to copy 2 types of files so I can archive them. I tested with a set of commands: touch -t $(date -d "-60 day" +%Y%m%d) WORKDIR/REF find TARGETDIR/ -type f -maxdepth 1 -iname \*.out\* -or -iname \*.log\* ! -newer WORKDIR/REF -exec ls -l {} \; This correctly lists any files in the... (2 Replies)
Discussion started by: prismtx
2 Replies

7. Shell Programming and Scripting

rsync is not correctly working

We are using Red Hat linux system. I am transferring my rman backup files to another server. Here is the command i am using to transfer the files. /usr/bin/rsync -avpP --delete /xyz/xyz/ 99.99.999.99::db110bkp Here is the rsync version. >rsync --version rsync version 3.0.6 ... (1 Reply)
Discussion started by: govindts
1 Replies

8. UNIX for Dummies Questions & Answers

Grep Regexp not working correctly

Consider the following code: grep -o -e '^STEAM_::\d+$' workfile3.tmp A sample format of a valid string for the regexp would be: STEAM_0:1:12345678 Here is an example line from the workfile3.tmp file: 465:L 01/02/2012 - 00:05:33: "Spartan1-1-7<8><STEAM_0:1:47539638><>" connected No... (2 Replies)
Discussion started by: spinner0205
2 Replies

9. UNIX for Dummies Questions & Answers

vnc No Longer Working Correctly

Hello All, Yesterday, all day, I was using x11vnc and vncviewer to connect to a server. But today for some reason it is not working. I don't remember changing any settings or anything like that, but because it stopped working correctly I guess something has...? I'm issuing the exact same... (0 Replies)
Discussion started by: mrm5102
0 Replies

10. UNIX for Beginners Questions & Answers

Are the brains of the UNIXoid working correctly?

Today I saw the topic. sum-even-numbers-1-100 At that time, it was already closed but not the point. Other thoughts came to mind. All newcomers to Haskell are afraid that when they study it, their brains will turn inside out. I did not notice anything like that. And all because the brains of all... (4 Replies)
Discussion started by: nezabudka
4 Replies
ISLOWER(3)						   BSD Library Functions Manual 						ISLOWER(3)

NAME
islower -- lower-case character test LIBRARY
Standard C Library (libc, -lc) SYNOPSIS
#include <ctype.h> int islower(int c); DESCRIPTION
The islower() function tests for any lower-case letters. The value of the argument must be representable as an unsigned char or the value of EOF. In the ASCII character set, this includes the following characters (with their numeric values shown in octal): 141 ``a'' 142 ``b'' 143 ``c'' 144 ``d'' 145 ``e'' 146 ``f'' 147 ``g'' 150 ``h'' 151 ``i'' 152 ``j'' 153 ``k'' 154 ``l'' 155 ``m'' 156 ``n'' 157 ``o'' 160 ``p'' 161 ``q'' 162 ``r'' 163 ``s'' 164 ``t'' 165 ``u'' 166 ``v'' 167 ``w'' 170 ``x'' 171 ``y'' 172 ``z'' RETURN VALUES
The islower() function returns zero if the character tests false and returns non-zero if the character tests true. COMPATIBILITY
The 4.4BSD extension of accepting arguments outside of the range of the unsigned char type in locales with large character sets is considered obsolete and may not be supported in future releases. The iswlower() function should be used instead. SEE ALSO
ctype(3), isalnum_l(3), iswlower(3), tolower(3), ascii(7) STANDARDS
The islower() function conforms to ISO/IEC 9899:1990 (``ISO C90''). BSD
July 17, 2005 BSD
All times are GMT -4. The time now is 01:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy