Sponsored Content
Full Discussion: awk not working correctly
Top Forums Shell Programming and Scripting awk not working correctly Post 302728125 by Junes on Wednesday 7th of November 2012 11:05:54 AM
Old 11-07-2012
awk not working correctly

Hi

I am attempting to right a script which will read a table and extract specfic information.

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



If i run the following command via CLI i get all the errors which meet the following cretia - $4=="150" || $4=="156", it seems that the syntax is ignorning "$1 >= "237308648" &&" and if written like this "$1 >= "$LASTFAILEDJOB" && " in the script


$1 = Checks for all failed job
$4 = If column $4 equals either 150 or 156

Code:
# bpdbjobs -most_columns | grep -i  | awk -F, '{if($1 >= "237308648" && $4=="150" || $4=="156") print $1, $4, $5, $7, $8, $12}'
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


I have even tried

Code:
bpdbjobs -most_columns | grep -i  | awk -F, '{if($1 > "237308646") print $0}' | awk -F, '{if($4=="150" || $4="=156")


Can you please help me rewrite the command, so all 18 lines appear and are greater than $LASTFAILEDJOB.

What i am noticing via the script is only the error codes with status 156 lines are being captured (11 lines out of potential 18)


Thanks
 

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
ROUTES(5)						       Network configuration							 ROUTES(5)

NAME
routes - configure the routing table SYNOPSIS
/etc/sysconfig/network/routes /etc/sysconfig/network/ifroute-* DESCRIPTION
The files /etc/sysconfig/network/routes and /etc/sysconfig/network/ifroute-config are parsed by the script /etc/sysconfig/net- work/scripts/ifup-route which sets up routing for an interface/configuration. ifup-route is used by /sbin/ifup, which is the command line user interface for setting up network interfaces. /etc/sysconfig/network/routes is used for every interface while /etc/sysconfig/network/ifroute-config is used only for the network inter- face configuration stored in /etc/sysconfig/network/ifcfg-config, that means only for a certain interface. (See a discussion of the notions configuration, interface and device in ifup(8).) At boot time /etc/init.d/network calls ifup for every existing configuration and uses ifup-route directly to set up special routes which do not belong to a certain interface. The current routes can be seen by issuing: /sbin/ip route list which will give the current routing table. Syntax The files /etc/sysconfig/network/routes and /etc/sysconfig/network/ifroute-config use the same syntax. The only difference is the interpre- tation of an empty interface field. See 4th column below. Lines beginning with # and blank lines are ignored. There are 5 columns with special meaning. Write a dash "-" if you want to omit an entry for a field. If all following fields in the line are empty too, you can even omit the dash. The first column gives the destination, written as the IP-address of a host or a network. The heading default indicates that the route is the default gateway. Do not use 0.0.0.0 for this purpose. A prefix-length (CIDR notation) can be used; e.g., 10.10.0.0/16 and also 10.10/16 are valid. The second column contains the gateway. Write here the regular IP-address of a host which routes the packets to a remote host or remote network. You can omit this information for rejecting routes. The third column gives the netmask for a remote host or remote network behind a gateway. For the default route or if you were using a pre- fix-length (CIDR notation) in the first column, you can omit it. The fourth column gives the name of the interface of the local networks (lo, eth0, eth1, isdn0, ppp0, dummy0, ...). If you leave this field empty the result depends on the file you are using. In /etc/sysconfig/network/routes the field is interpreted as no interface information available. That is sufficient for the most routes you may set up, but if you have multiple interfaces this route is set up with every single interface you activate. This may lead to error messages in the syslog. If you see such an error message which tells you "... this needs NOT to be AN ERROR" then check if you wrote the wrong ip addresses or if it occurs because it's being set up with the wrong interface. In the latter case you may want to use /etc/sysconfig/network/ifroute-config instead. Here an empty interface field is always replaced with the interface name that is currently being activated. This makes sense because this file is only used for one configuration (for one inter- face). Note: Static routes without explicit interfaces will also replace routes to the same destination (network) configured by dhcp clients on any interface! Static routes with explicit interface will also replace routes to the same destination (network) configured by dhcp clients on this inter- face. The fifth column can be used to specify the type of a route: unicast The route entry describes real paths to the destinations covered by the route prefix. local The destinations are assigned to this host. The packets are looped back and delivered locally. broadcast The destinations are broadcast addresses. The packets are sent as link broadcasts. multicast A special type used for multicast routing. It is not present in normal routing tables. throw A special control route used together with policy rules. If such a route is selected, lookup in this table is terminated pretending that no route was found. Without policy routing it is equivalent to the absence of the route in the routing table. The packets are dropped and the ICMP message net unreachable is generated. The local senders get an ENETUNREACH error. unreachable These destinations are unreachable. Packets are discarded silently. The local senders get an EINVAL error. prohibit These destinations are unreachable. Packets are discarded and the ICMP message communication administratively prohibited is gener- ated. The local senders get an EACCES error. blackhole These destinations are unreachable. Packets are discarded silently. The local senders get an EINVAL error. nat A special NAT route. Destinations covered by the prefix are considered to be dummy (or external) addresses which require translation to real (or internal) ones before forwarding. The addresses to translate to are selected with attribute 'via'. Any remaining columns, if given, are appended to the route command. This makes it possible to pass special options for this route. Columns which are not needed should contain a minus sign ( - ) to ensure that the parser correctly interprets the command. EXAMPLES
An example with common network interfaces and some static routes: # Destination Dummy/Gateway Netmask Interface # 127.0.0.0 0.0.0.0 255.255.255.0 lo 204.127.235.0 0.0.0.0 255.255.255.0 eth0 default 204.127.235.41 0.0.0.0 eth0 207.68.156.51 207.68.145.45 255.255.255.255 eth1 192.168.0.0 207.68.156.51 255.255.0.0 eth1 # --- same routes as above in CIDR notation: # Destination [Gateway] - Interface 127.0.0.0/8 - - lo 204.127.235.0/24 - - eth0 default 204.127.235.41 - eth0 207.68.156.51/32 207.68.145.45 - eth1 192.168.0.0/16 207.68.156.51 - eth1 # --- IPv6 routes are always using CIDR notation: # Destination [Gateway] - Interface 2001:DB8:100::/64 - - eth0 2001:DB8:100::/32 fe80::216:3eff:fe6d:c042 - eth0 An example for routing entries for synchronous ppp over a ISDN connection. # Destination Dummy/Gateway Netmask Interface # 127.0.0.0 0.0.0.0 255.255.255.0 lo 193.102.150.13 0.0.0.0 255.255.255.255 ippp0 default 193.102.150.13 0.0.0.0 ippp0 Note: Routes to directly connected network are created automatically (Linux kernel 2.4 and later) as soon as the IP address is assigned to the interface. For example, when the eth0 interface IP addresses are 204.127.235.42/24 and 2001:DB8:100::42/64, the following routes from above examples are created automatically: 204.127.235.0/24 - - eth0 2001:DB8:100::/64 - - eth0 and should be omitted. NOTES
SuSE Linux >= 8.0 uses the ip command from the iproute2 package to setup the network and routes. Please see the documentation distributed with this package for more information. FILES
/etc/sysconfig/network/routes /etc/sysconfig/network/ifroute-config AUTHOR
Michal Svec <msvec@suse.cz> Christian Zoz <zoz@suse.de> Mads Martin Joergensen <mmj@suse.de> Thanks to Werner Fink <werner@suse.de> for the old route.conf(5). Parts of the ip reference by Alexey Kuznetsov <kuznet@ms2.inr.ac.ru> were also used. SEE ALSO
init.d(7), init(8), inittab(5), the documentation for the iproute2 package and the SuSE Linux handbook, chapter The SuSE boot concept. sysconfig January 2003 ROUTES(5)
All times are GMT -4. The time now is 09:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy