Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help reformatting output

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help reformatting output
# 1  
Old 02-28-2011
Help reformatting output
I have a command that gives me the output below:
Code:
JAVA_HOME = C:/jdk1.5.0_11
Broker Performance Report for server 'app1'
 RMI_URL = rmis://
[DBConnectionBroker.getServerAdminReport]

Parameter                    Kintana ItgDS DashboardDS   
---------------------------- ------- ----- ----------- 
Connections count            41      1     1  
Connections available        2       1     1
Connections in use           39      0     0   
Max. Connections in use      -       4     2  
Pool Size                    45      45    15
Total Available              6       45    15
Wait queue size              0       -     -    
Avg. connection request time 0 ms    -     -
Connection recycle pct       100 %   -     -
Connection wait pct          0 %     -     -
Stmt cache hit pct           0 %     -     -    
Total connection requests    32791   -     -   
Logging enabled              false   -     -   



===========================================================================
Broker Performance Report for server 'app2'
 RMI_URL = rmis://
[DBConnectionBroker.getServerAdminReport]

Parameter                    Kintana ItgDS DashboardDS   
---------------------------- ------- ----- ----------- 
Connections count            4       2     1 
Connections available        4       2     1
Connections in use           0       0     0  
Max. Connections in use      -       2     1  
Pool Size                    45      45    15
Total Available              45      45    15 
Wait queue size              0       -     -    
Avg. connection request time 0 ms    -     -
Connection recycle pct       100 %   -     -
Connection wait pct          0 %     -     -
Stmt cache hit pct           0 %     -     -    
Total connection requests    1416    -     -  
Logging enabled              false   -     -   



===========================================================================
Broker Performance Report for server 'app3'
 RMI_URL = rmis://
[DBConnectionBroker.getServerAdminReport]

Parameter                    Kintana ItgDS DashboardDS   
---------------------------- ------- ----- ----------- 
Connections count            42      1     2  
Connections available        6       1     2
Connections in use           36      0     0   
Max. Connections in use      -       3     2  
Pool Size                    45      45    15
Total Available              9       45    15
Wait queue size              0       -     -    
Avg. connection request time 0 ms    -     -
Connection recycle pct       100 %   -     -
Connection wait pct          0 %     -     -
Stmt cache hit pct           0 %     -     -    
Total connection requests    24617   -     -   
Logging enabled              false   -     -   



===========================================================================
Broker Performance Report for server 'app4'
 RMI_URL = rmis://
[DBConnectionBroker.getServerAdminReport]

Parameter                    Kintana ItgDS DashboardDS   
---------------------------- ------- ----- ----------- 
Connections count            8       2     1 
Connections available        8       2     1
Connections in use           0       0     0  
Max. Connections in use      -       7     1  
Pool Size                    45      45    15
Total Available              45      45    15 
Wait queue size              0       -     -    
Avg. connection request time 0 ms    -     -
Connection recycle pct       100 %   -     -
Connection wait pct          0 %     -     -
Stmt cache hit pct           0 %     -     -    
Total connection requests    6853    -     -  
Logging enabled              false   -     -

I am looking to format it as follows, using only the output of column 1 and description for each node:
Code:
app1 Connections count 41
app1 Connections available 2
app1 Connections in use 39 
app1 Max. Connections in use 0
 
app2 Connections count 41
app2 Connections available 2
app2 Connections in use 39 
app2 Max. Connections in use 0

and so on (up through app4), but there could be between 2 and 10 app (nodes). I was going to use sed to drop the first few lines, then grep for 'Connections' but I couldn't figure out the awk commands for it. I figured it would be easier to understand if I just posted the whole problem, rather then just a part.

Any help (or ideas) is appreciated.

Last edited by Franklin52; 03-01-2011 at 04:57 AM.. Reason: Please use code tags, thank you
# 2  
Old 02-28-2011
Code:
awk '/app/{v=gensub(/'\''/,"","g",$NF)}
{if($0~/^Connections count/||$0~/^Connections available/||$0~/^Connections in use/||$0~/Max. Connections in use/)
{NF-=2;{$NF>0?$NF=$NF:$NF=0};print v FS $0}}' file

app node 2~10

Code:
awk '(/app[2-9]/||/app10/){v=gensub(/'\''/,"","g",$NF);print""}
{if(v>0 && ($0~/^Connections count/||$0~/^Connections available/||$0~/^Connections in use/||$0~/Max. Connections in use/))
{NF-=2;{$NF>0?$NF=$NF:$NF=0};print v FS $0}}' file

# 3  
Old 02-28-2011
are you look for this?
PHP Code:
awk '/Report for server/{aa=substr($6,2,length($6)-2);print ""}/^(Max\. )?Connections (count|available|in use)/{print aa" "$0}' ufile 
# 4  
Old 02-28-2011
Try...
Code:
awk '/^Broker/{s=$NF;print ""}/Connections (count|avail|in use)/{NF-=2;if($NF=="-")$NF=0;print s,$0}' file1

# 5  
Old 03-01-2011
MySQL
Ygor, that works perfectly. Thanks everyone for your help.

-bwiebe
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reformatting of an output file

Hi, i've got the following output file: 170724_1600 | SYSTEM | 449 | 282 | 167 | 62 170724_1600 | CCS_SCP_DATA | 200 | 88 | 112 | 44 170724_1600 | CCS_SCP_SUBS_I | 2001 | 1751 | 250 | 87 170724_1600 | UIS_CDR_INDEX | 2001 | 1 | 2000 | 0 170724_1600 | LCP_INDEX | 200 | 5 | 195 | 2... (4 Replies)
Discussion started by: nms
4 Replies

2. Shell Programming and Scripting

Help reformatting column

Hello UNIX experts, I'm stumped finding a method to reformat a column. Input file is a two column tab-delimited file. Essentially, for every term that appears in column 2, I would like to summarize whether that term appears for every entry in column 1. In other words, make a header for each term... (2 Replies)
Discussion started by: torchij
2 Replies

3. UNIX for Dummies Questions & Answers

Need help in reformatting the input

Hi i want to print line which is mentioned as below 615213:1;20150725;20250722;0|11;20150831;20150831;100|14;20150725;20160723;2 in below format. ' 615213: 1;20150725;20250722;0 615213: 11;20150831;20150831;100 615213: 14;20150725;20160723;2 please help me and suggest me how to... (9 Replies)
Discussion started by: scriptor
9 Replies

4. UNIX for Dummies Questions & Answers

Date reformatting

I have been reformatting dates from a data file to make them mysql compliant. 31-10-2011 Loc1 1-11-2011 Loc2 The first can be captured by this: sed -i '' -e "s#\(..\)-\(..\)-\(....\)#\3-\2-\1#" data.txt and leads to: 2011-10-31 Loc1 The second line is captured as follows: sed -i... (2 Replies)
Discussion started by: figaro
2 Replies

5. UNIX for Dummies Questions & Answers

Date reformatting

I have a file with temperature measurements: Loc1,20090102,71.55 Loc1,20090103,71.65 Loc1,20090104,71.55 Loc1,20090105,71.54 Loc1,20090106,71.54 However, to load this into a database I would like to reformat the dates (column 2) from the yyyymmdd format to the yyyy-mm-dd format. I have... (2 Replies)
Discussion started by: figaro
2 Replies

6. UNIX for Dummies Questions & Answers

Date reformatting

I currently have the following file containing sample values for a number of dates: Loc1 04 Jan 2007 0.95 0.9532 Loc1 05 Jan 2007 0.95 0.9513 Loc1 06 Jan 2007 0.95 0.9535 This continues for all months of the year and spans across several years. I am trying to reformat the dates so that... (2 Replies)
Discussion started by: figaro
2 Replies

7. Shell Programming and Scripting

Searching pattern and reformatting

Hi, I have a file whose sample data is as below: Rak 654 JM30 20100215 387898263 7867556789 RPT 654 TM38 20100215 827384652 9786735628 RNP DCB 342 TM38 20100215 876782372 2323786527 Rak 654 JM30 20100215 328564893 8862573828 RNN 684 SK20 20100215 926738429 8283927457 RPP TKS 20100215... (10 Replies)
Discussion started by: rochitsharma
10 Replies

8. UNIX for Dummies Questions & Answers

Reformatting file

Hi, How can I reformat a file (text file) using unix command. This file was FTP'd from Mainframe and contains some garbage character at the end of each line. Each line contains special characters '<soh>' at the end which should have been spaces when I view it in emacs or nedit. I couldnt do find... (2 Replies)
Discussion started by: mrjunsy
2 Replies

9. Shell Programming and Scripting

Help capturing and reformatting buffered and unbuffered output

Ok, so I have a shell script which runs a specific command, and that command sends it's output to the display. At certain times, the command sends buffered output, and at other times, the command sends unbuffered output in the form of a % progress bar, so if I run the command, the output I receive... (0 Replies)
Discussion started by: vikingshelmut
0 Replies

10. Filesystems, Disks and Memory

reformatting a floppy!

i am trying to reformat a floppy i am using solaris 9 when i run this: rmformat -F quick /vol/dev/aliases/floppy0 it tells me that it cannot perform the operation on a mounted device. how do i unmount the device and format the floppy? (1 Reply)
Discussion started by: rmuhammad
1 Replies
Login or Register to Ask a Question