Shell Programming and Scripting

This is my script. I am pulling the status of some hard where, but the status is in numerical form. The number 4 means Major and the 5 means Critical. In my script I would like to show the alarm type in aplha rather than numeric form. So if instead of seeing a 4 or 5 you would see MAjor or Critical. I want to use an if becuase I have a few more types but I am trying to keep it simple so I can grasp the concept. I also attached a sample out of my commmand file.

dalsys:dalmso2 > more acgstatus
#!/bin/ksh
# Description:
# This script will pull load info for network NEs.
# Nextel Dallas
# By MSO Tech II Jason C. Kelsey
db=airgen_cm_db@urban_dbhost

tacg=`echo "select a.neinstanceid, a.almacgcomentseverity, b.neinstanceid, b.nename from nmo_almacgcomentry a, neentry b where a.neinstanceid=b.neinstance
id group by b.neinstanceid, b.nename, a.neinstanceid, a.almacgcomentseverity" | /usr/informix/bin/dbaccess $db`

echo "
| | | |
b.neinstanceid.| b.nename | a.neinstanceid.a|a.almacgcomentseverity|
---------------|-----------|-----------------|----------------------|----"

echo $tacg

if [ "" = "4" ]
then {
="Major"
}
fi

if [ "" = "5" ]
then {
="Critical"
}
fi

Output currently:
Here is the put without the if statments...........................
dalsys:dalmso2 > acgstatus
Database selected.
4452 row(s) retrieved.
Database closed.
| | | |
neinstanceid | almacgcomentsever+ | neinstanceid | nename |
---------------|--------------------|-----------------|----------------|----
neinstanceid almacgcomentsever+ neinstanceid nename

9041 4 9041 NTX0322R_IDBEACHBRD
32555 5 32555 NOK3410R_IZNEMIAMI
64586 4 64586 PTX389PR_IVSEBRNVIL
1176 4 1176 NTX1401R_IHCENTERFI
470 4 470 NTX0182R_IDOOOI35_U
62737 4 62737 PTX324PR_ICN_ALICE
63715 4 63715 PTX569PR_IWATLANTA
65711 5 65711 PTX123PR_IBSLUMBERT
69746 4 69746 NTX1822R_IHKATYHAWK
28013 4 28013 NTX1407R_IHFONVILLA
448 4 448 NTX0130R_IDGARLAND

I would be much appricated, I have been at since 2am.. ;-)

The easiest way that I can think of is to use sed(1) rather than a shell if statement. It's quite simple. Your output is saved in file but can also be piped into the sed command.

# cat file | sed -e "s/^\([0-9][0-9]*\) 4 /\1 Major /" -e "s/^\([0-9][0-9]*\) 5 /\1 Critical /"
9041 Major 9041 NTX0322R_IDBEACHBRD
32555 Critical 32555 NOK3410R_IZNEMIAMI
64586 Major 64586 PTX389PR_IVSEBRNVIL
1176 Major 1176 NTX1401R_IHCENTERFI
470 Major 470 NTX0182R_IDOOOI35_U
62737 Major 62737 PTX324PR_ICN_ALICE
63715 Major 63715 PTX569PR_IWATLANTA
65711 Critical 65711 PTX123PR_IBSLUMBERT
69746 Major 69746 NTX1822R_IHKATYHAWK
28013 Major 28013 NTX1407R_IHFONVILLA
448 Major 448 NTX0130R_IDGARLAND


To add additional value translations, just and another "-e script" option. The syntax is

-e 's/^\([0-9][0-9]*\) number /\1 string /"

which says, on a line starting with one or more digits, then a space, another number, and one more space, substitute with the original starting digits, a space, a new string and a space.

I am trying to get a bit more into the arguementive script, because I have another script I am working on and sed would become a problem. I would like to keep it simple and neat. I apprecate the reply though and any more details will be very help full. Thanks again. I am just looking to get the understanding of a simple if statement. I am one that will not stop until I complete something that has been stumping me. This if statement has, I have been battling now going on 20hrs straight.

Thanks Get ur Done.|

You can use awk for this job, maybe this is easier to understand:

Code:

awk '{ ($2 == 4)? $2 = "Major": $2 = "Critical"} {print}' datafile

If $2 = 4 then $2 = "Major" else $2 = "Critical"; print the line

Regards

Now i am pretty familar with awk but it appears you are using it in a csh format. Am I mistaken? I ihave payed with it abit and continuiously get a awk statement failure.

It appears it woud work can you help me a bit more by giving me example using my script above. I have been negecting my house work. I am a singe father, so you know the wash is stacked, and the dished are growing, but I am determinded to competed this script before I wak into work tomorrow.

My co workers and boss are all ignorate to scripting and see no reason of logic behind using it. they think I am crazy, I have worked in telecom for 6 years, and never did I want, have, or even used a gui point and click.

There is no CLI with the network I am on. Moto got them locked to a GUI patform. So I have taken it apon my mysef to dig out of informix / dbaccess and use the mib to get accual and factual data. Long story short, it wil.l feel goood to rub this script it there face, that they have snickered amoung them seleves saying it could not be done.

Thanks 4 everyones support .|

No, I'm using Bash and it also works with the ksh on a HP-UX system.

Try this in your script:

Code:

echo $tacg|awk '{ ($2 == 4)? $2 = "Major": $2 = "Critical"} {print}'

instead of this:

Code:

echo $tacg
f [ "" = "4" ]
then {
="Major"
}
fi

if [ "" = "5" ]
then {
="Critical"
}
fi

Regards

"acgstatus" 17 lines, 743 characters
dalsys:dalmso2 > acgstatus

Database selected.
# By MSO Tech II Jason C. Kelsey
db=airgen_cm_db@urban_dbhost
tacg=`echo "select a.neinstanceid, a.almacgcomentseverity, b.neinstanceid, b.nen
ame from nmo_almacgcomentry a, neentry b where a.neinstanceid=b.neinstanceid gro
up by b.neinstanceid, b.nename, a.neinstanceid, a.almacgcomentseverity" | /usr/i
nformix/bin/dbaccess $db`

echo "
| | | |
neinstanceid | almacgcomentsever+ | neinstanceid | nename |
---------------|--------------------|-----------------|----------------|----"


echo $tacg|awk '{ ($2 == 4)? $2 = "Major": $2 = "Critical"} {print}'
~
~
~
6 fewer lines in file after visual
:wq!
-----------------------------------------------------------------------

4452 row(s) retrieved.


Database closed.


| | | |
neinstanceid | almacgcomentsever+ | neinstanceid | nename |
---------------|--------------------|-----------------|----------------|----
awk: syntax error near line 1
awk: illegal statement near line 1
dalsys:dalmso2 > ^C


it is all most there, otherwise it would have spit out a bunch of junk. I see what I can do with it till I hear from you again. ;-) Thx