10-10-2018
That report is one single file. I know how to get awk to give me the last field (Difference) if there were no headings. What I don't know how or if I and do is skip the headings and column names and just go after the data.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to create a report using the following syntax:
#!/bin/awk -f
#script name: users_report
BEGIN { FS=":" ; OFS="\t" ; print "User\tGID\tUser Name\tHome Dir\t"
{ print $1 , $3 , $5 , $6 }
END { print "\n End of Report \n" }
$> user_report /etc/passwd
the output of... (5 Replies)
Discussion started by: ghazi
5 Replies
2. Shell Programming and Scripting
I have many text file reports generated by a Information Assurance tool that I need to get into a .CSV format or Excel tab delimited format. I want to use sed or awk to grab all the information in the sample text file below and create column headings:Risk ID, Risk Level, Category, Description, How... (5 Replies)
Discussion started by: Bjoeboo
5 Replies
3. UNIX for Dummies Questions & Answers
I'm trying to see if there's a way to see column headings when I type the
ls -l command.
I know what some of the fields mean for example in the following listing:
total 136
drwxr-xr-x 2 root root 4096 Jun 5 15:16 bin
drwxr-xr-x 3 root root 4096 Jul 9 15:25 boot
drwxr-xr-x 9... (6 Replies)
Discussion started by: thoughts
6 Replies
4. AIX
I need help to split a filename 'a0crk_user:A0-B0123$#%test' into a0crk_user and A0-B0123 and print the output under 2 different columns namely
User and Status.
for eg. the output should like below:
User Status
---- ------
a0crk_user A0-B0123 (3 Replies)
Discussion started by: mbak
3 Replies
5. Shell Programming and Scripting
Hello,
I'm rather new to the world of regular expressions and sed, though am excited by its possibilities. I have a particular task I'd like to achieve, and have googled the topic quite a bit. However, having found some codes that perform a task very similar to what I'd like to do, I can't for... (2 Replies)
Discussion started by: redseventyseven
2 Replies
6. Shell Programming and Scripting
home directory = /export/home/jenovaux/
/log
Contain 3 file
/filename1.log
/filename2.log
/filename3.log
each file from this file is a log for job
each file contain success or failed
I want to make awk report as the following:-
LOGFILENAME ... (1 Reply)
Discussion started by: jenovaux
1 Replies
7. Shell Programming and Scripting
Hello all,
Here is what my bash script does: sums number columns, saves the tot in new column, outputs if tot >= threshold val:
> cat getnon0file.sh
#!/bin/bash
this="getnon0file.sh"
USAGE=$this"
InFile="xyz.38"
Min="0.05"
#
awk '{sum=0; for(n=2; n<=NF; n++){sum+=$n};... (4 Replies)
Discussion started by: catalys
4 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I need your help in adding column headings in the below report.
The headings I want are:
Count - Host - Message Type
The command used to create the report is as follows:
for messages in `cat syslog_message_list.txt`
do
grep $messages syslog.`date +%d%m%y`.log | awk '{print $4 " " "... (4 Replies)
Discussion started by: wthomas
4 Replies
9. UNIX for Dummies Questions & Answers
Hi all,
I have a file with 3 columns separated by space. Each column has a heading. I want to sort according to the values in the 2nd column (ascending order).
Ex.
Name rank direction
goory 0.05 --+
laby 0.0006 ---
namy 0.31 -+-
....etc.
Output should be
Name rank direction
laby... (3 Replies)
Discussion started by: Unilearn
3 Replies
10. Shell Programming and Scripting
HI I am executing faloowing commands.
mr batch_1 > my_temp.txt ;
mr batch_2 >>my_temp.txt;
mr batch_3 >> my_temp.txt;
mr batch_4 >> my_temp.txt;
and the out put file is as this
cat my_temp.txt
Machine Name Max Load Current Load Factor O/S Status... (3 Replies)
Discussion started by: ptappeta
3 Replies
LEARN ABOUT XFREE86
snmptable
SNMPTABLE(1) Net-SNMP SNMPTABLE(1)
NAME
snmptable - retrieve an SNMP table and display it in tabular form
SYNOPSIS
snmptable [COMMON OPTIONS] [-Cb] [-CB] [-Ch] [-CH] [-Ci] [-Cf STRING] [-Cw WIDTH] AGENT TABLE-OID
DESCRIPTION
snmptable is an SNMP application that repeatedly uses the SNMP GETNEXT or GETBULK requests to query for information on a network entity.
The parameter TABLE-OID must specify an SNMP table.
snmptable is an SNMP application that repeatedly uses the SNMP GETNEXT or GETBULK requests to query for information on a network entity.
The parameter TABLE-OID must specify an SNMP table.
AGENT identifies a target SNMP agent, which is instrumented to monitor the gievn objects. At its simplest, the AGENT specification will
consist of a hostname or an IPv4 address. In this situation, the command will attempt communication with the agent, using UDP/IPv4 to port
161 of the given target host. See snmpcmd(1) for a full list of the possible formats for AGENT.
OPTIONS
COMMON OPTIONS
Please see snmpcmd(1) for a list of possible values for COMMON OPTIONS as well as their descriptions.
-Cb Display only a brief heading. Any common prefix of the table field names will be deleted.
-CB Do not use GETBULK requests to retrieve data, only GETNEXT.
-Cc CHARS
Print table in columns of CHARS characters width.
-Cf STRING
The string STRING is used to separate table columns. With this option, each table entry will be printed in compact form, just with
the string given to separate the columns (useful if you want to import it into a database). Otherwise it is printed in nicely
aligned columns.
-Ch Display only the column headings.
-CH Do not display the column headings.
-Ci This option prepends the index of the entry to all printed lines.
-Cl Left justify the data in each column.
-Cr REPEATERS
For GETBULK requests, REPEATERS specifies the max-repeaters value to use. For GETNEXT requests, REPEATERS specifies the number of
entries to retrieve at a time.
-Cw WIDTH
Specifies the width of the lines when the table is printed. If the lines will be longer, the table will be printed in sections of
at most WIDTH characters. If WIDTH is less than the length of the contents of a single column, then that single column will still
be printed.
EXAMPLES
$ snmptable -v 2c -c public localhost at.atTable
SNMP table: at.atTable RFC1213-MIB::atTable
atIfIndex atPhysAddress atNetAddress
1 8:0:20:20:0:ab 130.225.243.33
$ snmptable -v 2c -c public -Cf + localhost at.atTable
SNMP table: at.atTable
atIfIndex+atPhysAddress+atNetAddress 1+8:0:20:20:0:ab+130.225.243.33
$ snmptable localhost -Cl -CB -Ci -OX -Cb -Cc 16 -Cw 64 ifTable
SNMP table: ifTable
Index Descr Type Mtu
Speed PhysAddress AdminStatus OperStatus
LastChange InOctets InUcastPkts InNUcastPkts
InDiscards InErrors InUnknownProtos OutOctets
OutUcastPkts OutNUcastPkts OutDiscards OutErrors
OutQLen Specific
index: [1]
1 lo softwareLoopbac 16436
10000000 up up
? 2837283786 3052466 ?
0 0 ? 2837283786
3052466 ? 0 0
0 zeroDotZero
index: [2]
2 eth0 ethernetCsmacd 1500
10000000 0:5:5d:d1:f7:cf up up
? 2052604234 44252973 ?
0 0 ? 149778187
65897282 ? 0 0
0 zeroDotZero
BUGS
The test for TABLE-OID actually specifying a table is rather heuristic. Note also that the test requires the defining MIB file to be
loaded.
SEE ALSO
snmpcmd(1), variables(5).
4th Berkeley Distribution 25 Jul 2003 SNMPTABLE(1)