Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Output top line for each unique host Post 302993917 by Junes on Thursday 16th of March 2017 08:49:13 AM
Old 03-16-2017
These are backup jobs... The report keeps last 3 days worth of data. Hence when I run the tool commands "bpdbjobs -most_columns ", it shows more than one day of output.

Code:
bpdbjobs -most_columns | awk '!a[$3]++'

The following command works fine, but if a job has completed (provides the unique of column 3).

The script output is correct, because $3 for line output 2 and 4 are unique. -

Code:
243286674 3 sv204135 LDN_CAM_NT_PRD_VMWARE_SQL 1489629600 0000000324 1 INC_1MTH 1
 **** 243286673 1 nbnesln1p02 INC_1MTH 0000023162 0000000000 3 sv204134 LDN_WAT_NT_PRD_VMWARE_SQL                    (Job Running - should be reported)
243286157 3 sv204133 LDN_WAT_NT_PRD_VMWARE 1489604401 0000000707 1 INC_1MTH 1
***** 243285912 3 sv204134 LDN_WAT_NT_PRD_VMWARE_SQL 1489543200 0000029480 1 INC_1MTH 1                           (Job Completed - should not be reported)


I need to perform a comparison $3 and $8, which give the same string and it will choose the line, which in $8.

I hope this make more sense

---------- Post updated at 12:49 PM ---------- Previous update was at 10:23 AM ----------

I found a different way to get the output, at the end of the script. Using the following command for the output

Code:
awk '!a[$2]++'

 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

top output

Hi all, below is the output of my 'top' Tasks: 91 total, 2 running, 89 sleeping, 0 stopped, 0 zombie Cpu(s): 3.9% us, 20.5% sy, 0.0% ni, 75.6% id, 0.0% wa, 0.0% hi, 0.0% si Can someone tell me what does us, sy,ni,id,wa,hi,si stands stand for? (4 Replies)
Discussion started by: new2ss
4 Replies

2. Shell Programming and Scripting

capturing output from top and format output

Hi all, I'd like to capture the output from the 'top' command to monitor my CPU and Mem utilisation.Currently my command isecho date `top -b -n1 | grep -e Cpu -e Mem` I get the output in 3 separate lines.Tue Feb 24 15:00:03 Cpu(s): 3.4% us, 8.5% sy .. .. Mem: 1011480k total, 226928k used, ....... (4 Replies)
Discussion started by: new2ss
4 Replies

3. Shell Programming and Scripting

top output for six processes with the same name, output changed from column to row

Hi, I have a system under test, and I use a script that does a ps. The output, is in the following format, it's basically the timestamp, followed by the rss and vsize. 09:03:57 68404 183656 68312 181944 69860 217360 67536 182564 69072 183172 69032 199276 09:04:27 68752 183292 70000 189020... (5 Replies)
Discussion started by: Bloke
5 Replies

4. Solaris

top output and swap -s output are differing

Solaris experts, Am struggling, and wondering for the past more than one week that, how to calculate the total available and used memory/swap space. Finally installed and used top & got some understanding, but while cross-checking, there are mismatches. Main Memory top o/p - 2GB... (7 Replies)
Discussion started by: thegeek
7 Replies

5. Shell Programming and Scripting

grep with date & unique output

alert.log has the entries with ORA-XXXX, .... Mon Sep 24 15:08:09 2012 WARNING: inbound connection timed out (ORA-3136) Mon Sep 24 15:08:09 2012 WARNING: inbound connection timed out (ORA-3136) Mon Sep 24 15:08:09 2012 WARNING: inbound connection timed out (ORA-3136) Mon Sep 24 15:15:01... (4 Replies)
Discussion started by: Daniel Gate
4 Replies

6. Shell Programming and Scripting

How to get unique of file1 from file2 and save the output?

Please help, file1.txt 1 2 3 4 5 file2.txt 3 4 5 6 7 All I need is this result.txt 1 2 (17 Replies)
Discussion started by: richmac
17 Replies

7. Shell Programming and Scripting

Output first unique record in csv file

Hi, I have to output a new csv file from an input csv file with first unique value in the first column. input csv file color product id status green 102 pass yellow 201 hold yellow 202 keep green 101 ok green 103 hold yellow 203 ... (5 Replies)
Discussion started by: Chris LAU
5 Replies

8. Solaris

Host name in front of ps output

hello All. I am working on something that should be really simply. It turns out that its not. I am trying to produce output to list the hostname along with all the current running programs. the script im using is: for PS in `ps -Ao "user,args" | cut -d' ' -f1,2` do echo "`uname -n`, $PS"... (5 Replies)
Discussion started by: busi386
5 Replies

9. Shell Programming and Scripting

Sorting out unique values from output of for loop.

Hi , i have a belwo script which is used to get sectors per track value extarcted from Solaris machine: for DISK in /dev/dsk/c*t*d*s*; do value=`prtvtoc "$DISK" | sed -n -e '/Dimensions/,/Flags/{/Dimensions/d; /Flags/d; p; }' | sed -n -e '/sectors\/track/p'`; if ; then echo... (4 Replies)
Discussion started by: omkar.jadhav
4 Replies

10. UNIX for Beginners Questions & Answers

Get an output of lines in pattern 1st line then 10th line then 11th line then 20th line and so on.

Input file: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 (6 Replies)
Discussion started by: Sagar Singh
6 Replies
gdlpp(1)																  gdlpp(1)

NAME
gdlpp - GDL (Graphite Description Language) preprocessor SYNOPSIS
gdlpp [options] [infile [outfile] ] OPTIONS
-B No machine specific built-in symbols -b Output any parentheses, brace or bracket unbalance -C Write source file comments to output -D Define a symbol with the given (optional) value "symbol[=value]" -d Display all specified options -E Ignore non-fatal errors -F Output all included file names on stderr -f Output all defined functions' names on stderr -H Output all whitespaces from the source file -h Output this help text -I Add directory to the #include search list -J Allow nested comments -j Enable warnings for nested comments -LL Don't output #line instructions -L Don't output the 'line' keyword in "#line" instructions -M Don't warn for missing include files -N Don't predefine target-specific names -n Toggle prefs usage -P Don't recognize C++ comment style -p Enable warnings on non ANSI preprocessor instructions -Q Ignore but visualize undefined flags -q Ignore all undefined flags -R Evaluate the right part first in symbol concatenations -s Include the following string at the top of each function -S Specify sizes for #if sizeof -t This function should not get an initial function -U Undefine symbol -V Output version information -W Output all #defines -WWW Web mode preprocessing -w Only output #defines -X Include file grcompiler 25 February 2011 gdlpp(1)
All times are GMT -4. The time now is 11:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy