Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need help the sum from loop

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help the sum from loop
# 1  
Old 05-25-2017
Lightbulb Need help the sum from loop
Hi all,

I have one host i need to run in loop to check the capacity from different frame and get the output to one file and sum it and convert to TB

this is Code

Code:
#!/bin/ksh
DATE=`date '+%d%m%y'`
for f in `cat /home/esx-capacity/esx-host.txt`
do
for g in `cat /home/esx-capacity/frame`
do
 symaccess -sid $g  list devinfo -ig $f |grep -i total |awk '{print $3} > /home/esx-capacity/num
done
done

echo $g - num >>  Report

esx-host.txt -test1server
frame -123,234,345

I need to get the capacity from each frame and sum all and provide the output as below
test1server - 1000 TB
# 2  
Old 05-25-2017
Code:
#!/bin/ksh
DATE=`date '+%d%m%y'`
while read f
do
   tr ',' '\n' < /home/esx-capacity/frame | while read g
   do
      symaccess -sid $g  list devinfo -ig $f
   done | grep -i total | awk '{t+=$3} END {print f " - " t}' f=$f
done < /home/esx-capacity/esx-host.txt > /home/esx-capacity/Report

Last edited by rdrtx1; 05-25-2017 at 04:38 PM..
# 3  
Old 05-26-2017
hi rdrtx1
Script executed without error but no output has come in report
# 4  
Old 05-26-2017
What is the output from this script?
Code:
#!/bin/ksh
DATE=`date '+%d%m%y'`
while read f
do
   tr ',' '\n' < /home/esx-capacity/frame | while read g
   do
      symaccess -sid $g  list devinfo -ig $f
   done | grep -i total
done < /home/esx-capacity/esx-host.txt

# 5  
Old 05-26-2017
I don't see any output just blank
# 6  
Old 05-26-2017
and from this?:
Code:
#!/bin/ksh
DATE=`date '+%d%m%y'`
while read f
do
   tr ',' '\n' < /home/esx-capacity/frame | while read g
   do
      echo "$g:::$f"
      #symaccess -sid $g  list devinfo -ig $f
   done
done < /home/esx-capacity/esx-host.txt

What it the output from the symaccess command?
# 7  
Old 05-26-2017
For symaccess below is output
Code:
symaccess -sid 222  list devinfo -ig ceetest041 |grep -i total
Total Capacity                                   9839983

This the output from multiple frame
Code:
$ cat Report |grep ceetest041
295700084       ceetest041     Total   Capacity        1053089
295700624       ceetest041     Total   Capacity        48
295700826       ceetest041     Total   Capacity        53
295700831       ceetest041     Total   Capacity        12
222     ceetest041     Total   Capacity        31073660
261     ceetest041     Total   Capacity        10357912

I need the output

Code:
ceetest041  -1053089+48+53+12+31073660+10357912 SUM=total Value

Last edited by Don Cragun; 05-26-2017 at 07:25 PM.. Reason: Change QUOTE tags to CODE tags, and add CODE tags.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Post Here to Contact Site Administrators and Moderators

awk to sum in Loop

i want code in awk with loop to get the sum * is delimiter in file TOTAL_AMOUNT=SUM(CLP04) suppose there are 12 CLP04 segment in my file i want to add upto 5 CLP04 then print next line after BPR segment after calculate the total amount CLP04 means ex ... (5 Replies)
Discussion started by: MOHANP12
5 Replies

2. Shell Programming and Scripting

Sum up numbers in a for loop

Hi i have to calculate some numbers, column by column. Herfore i used a for-loop.. for i in {4..26};do awk -F"," '{x'$i'+=$'$i'}END{print '$i'"\t" x'$i'}' file.tmp;done ----- printout ----- 4 660905240 5 71205272 6 8.26169e+07 7 8.85961e+07 8 8.60936e+07 9 7.42238e+07 10 5.6051e+07... (7 Replies)
Discussion started by: IMPe
7 Replies

3. Shell Programming and Scripting

awk loop using array:wish to store array values from loop for use outside loop

Here's my code: awk -F '' 'NR==FNR { if (/time/ && $5>10) A=$2" "$3":"$4":"($5-01) else if (/time/ && $5<01) A=$2" "$3":"$4-01":"(59-$5) else if (/time/ && $5<=10) A=$2" "$3":"$4":0"($5-01) else if (/close/) { B=0 n1=n2; ... (2 Replies)
Discussion started by: klane
2 Replies

4. Shell Programming and Scripting

For Loop & SUM

pcmpath query device |awk 'BEGIN{print "DEVICE NAME\tSERIAL"} /DEVICE NAME/ {printf "%s\t", $5; getline; print substr($2, length($2)-3)}' This script returns output like below to pull out "DEVICE NAME SERIAL". ...... hdisk28 110B hdisk29 1112 hdisk30 1115 hdisk31 1116 hdisk32 1128... (2 Replies)
Discussion started by: Daniel Gate
2 Replies

5. Shell Programming and Scripting

Loop through file to sum conditionally

Hi, I have a file with header, detail and trailer records. HDR|111 DTL|abc|100|xyz DTL|abc|50|xyz TRL|150 I need to add the values in 3rd field from DTL records. Using awk, I am doing it as follows: awk -F'|' '$1=="DTL"{a += $3} END {print a}' <source_file> However, I want to... (3 Replies)
Discussion started by: delta21
3 Replies

6. Shell Programming and Scripting

loop + sum + print using awk

Hi, I am unable sum of each column in the loop usng awk command. Awk is not allowing the parameters in the command. i am facing the below error. awk: 0602-562 Field $() is not correct. Source file abc.txt 100,200,300,400,500,600,700,800,900 101,201,301,401,501,601,701,801,901 ... (1 Reply)
Discussion started by: number10
1 Replies

7. Shell Programming and Scripting

Print sum and relative value of the sum

Hi i data looks like this: student 1 Subject1 45 55 Subject2 44 55 Subject3 33 44 // student 2 Subject1 45 55 Subject2 44 55 Subject3 33 44 i would like to sum $2, $3 (marks) and divide each entry in $2 and $3 with their respective sums and print for each student as $4 and... (2 Replies)
Discussion started by: saint2006
2 Replies

8. Shell Programming and Scripting

Using variables created sequentially in a loop while still inside of the loop [bash]

I'm trying to understand if it's possible to create a set of variables that are numbered based on another variable (using eval) in a loop, and then call on it before the loop ends. As an example I've written a script called question (The fist command is to show what is the contents of the... (2 Replies)
Discussion started by: DeCoTwc
2 Replies

9. Shell Programming and Scripting

While loop - The sum seems to be local

Hi, I am trying to extracting the sum of all varibles listed in a file. The code is as follows ##### FILE1 ######## Value1:2 Value2:2 Value3:6 Value4:5 ##### shell script ###### #!/bin/sh total=0 (2 Replies)
Discussion started by: eagercyber
2 Replies
Login or Register to Ask a Question