Sponsored Content
Top Forums Shell Programming and Scripting Compare two files and merge columns in a third Post 302113271 by vgersh99 on Wednesday 4th of April 2007 01:25:08 PM
Old 04-04-2007
how about this:
Code:
GET () { 
     while read Host
     do
         snmpwalk -Onq $Host $Pass $1 | sed -e s/^$1\.// -e s/\"//g | sort >> "/tmp/${Host}.txt"
     done < "${HostFile}"
   }  

for OID in Mac Port
do eval "GET \$$OID" ; done

I just removed the file redirection from the 'for' loop, but you might need it for your 'JOIN'. WIth the redirection removed you should get ONE file (for both Mac and Port) for ONE host all in ONE file. I'm not sure if that's what you're looking for as a final result.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

compare the column from 3 files and merge that line

I have 3 file, each of has got 80000 records. file1.txt ----------------------- ABC001;active;modify;accept; ABC002;notactive;modify;accept; ABC003;notactive;no-modify;accept; ABC004;active;modify;accept; ABC005;active;no-modify;accept; file2.txt ---------------------------... (8 Replies)
Discussion started by: ganesh_mak
8 Replies

2. UNIX for Dummies Questions & Answers

compare columns from 2 files and merge

Dear all, Being new to Unix i have a problem. I have 2 files: File 1: 118,1,0,2,3,0,5,0.3,0,0.3,0.6,1 118,2,1,2,2,0,5,0.4,0,0.4,0.4,1 118,4,2,0,3,0,5,0.7,0,0.3,0.6,1 118,6,4,1,0,0,5,0.8,0,0.2,0,1 File 2: 118,1,BFGL-NGS-109695,3610326,0,18,1,0.556,0.389,0.056,0.25,0.8183... (2 Replies)
Discussion started by: samwilkinson
2 Replies

3. Shell Programming and Scripting

merge the two files which has contain columns

Hi may i ask how to accomplish this task: I have 2 files which has multiple columns first file 1 a 2 b 3 c 4 d second file 14 a 9 .... 13 b 10.... 12 c 11... 11 d 12... I want to merge the second file to first file that will looks like this ... (2 Replies)
Discussion started by: jao_madn
2 Replies

4. UNIX for Dummies Questions & Answers

Merge two files with two columns being similar

Hi everyone. How can I merge two files, where each file has 2 columns and the first columns in both files are similar? I want all in a file of 4 columns; join command removes the duplicate columns. 1 Dave 2 Mark 3 Paul 1 Apple 2 Orange 3 Grapes to get it like this in the 3rd file:... (9 Replies)
Discussion started by: Atrisa
9 Replies

5. Shell Programming and Scripting

Merge columns of different files

Hi, I have tab limited file 1 and tab limited file 2 The output should contain common first column vales and corresponding 2nd column values; AND also unique first column value with corresponding 2nd column value of the file that contains it and 0 for the second file. the output should... (10 Replies)
Discussion started by: polsum
10 Replies

6. Shell Programming and Scripting

Compare and Merge files

Hi All, I have two different files as shown below separated by a "|". I need to compare the first column from both the files and if they match merge both the columns. File 1 "S00172012"|"CHRONIC RENAL FAILURE"|""|"I" "S00159962"|"SUBENDO INFRC-INIT EPISD"|""|"I" "S00255303"|"BENIGN... (6 Replies)
Discussion started by: nua7
6 Replies

7. Shell Programming and Scripting

Merge columns on different files

Hello, I have two files that have this format: file 1 86.82 0.00 86.82 43.61 86.84 0.00 86.84 43.61 86.86 0.00 86.86 43.61 86.88 0.00 86.88 43.61 file 2 86.82 0.22 86.84 0.22 86.86 0.22 86.88 0.22 I would like to merge these two files such that the final file looks like... (5 Replies)
Discussion started by: kayak
5 Replies

8. Shell Programming and Scripting

Compare two files and merge into third

Hello: Newbie with Awk. Trying to compare two files and merge data based on CID. Please see the input file format and desired output. Any help is appreciated. TIA Input File1 CID1 --- TYP1 --- DCN1 --- INDATE1 --- IN-DATA1 CID2 --- TYP2 --- DCN2 --- INDATE2 --- IN-DATA2 CID3 ---... (6 Replies)
Discussion started by: wincrazy
6 Replies

9. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

10. Shell Programming and Scripting

Compare and merge two big CSV files

Hi all, i need help. I have two csv files with a huge amount of data. I need the first column of the first file, to be compared with the data of the second, to have at the end a file with the data not present in the second file. Example File1: (only one column) profile_id 57036226... (11 Replies)
Discussion started by: SirMannu
11 Replies
snmpdx(1M)						  System Administration Commands						snmpdx(1M)

NAME
snmpdx - Sun Solstice Enterprise Master Agent SYNOPSIS
/usr/lib/snmp/snmpdx [-hy] [-a filename] [-c config-dir] [-d debug-level] [-i filename] [ -m GROUP -m SPLIT] [-o filename] [-p port] [-r filename] DESCRIPTION
The Master Agent, snmpdx, is the main component of Solstice Enterprise Agent technology. It runs as a daemon process and listens to User Datagram Protocol (UDP) port 161 for SNMP requests. The Master Agent also opens another port to receive SNMP trap notifications from vari- ous subagents. These traps are forwarded to various managers, as determined by the configuration file. Upon invocation, snmpdx reads its various configuration files and takes appropriate actions by activating subagents, determining the sub- tree Object Identifier (OID) for various subagents, populating its own Management Information Bases (MIBs), and so forth. The Master Agent invokes subagents, registers subagents, sends requests to subagents, receives responses from subagents, and traps notifications from sub- agents. The Master Agent is invoked from a start-up script at boot time only if contents of the resource configuration file /etc/snmp/conf/snm- pdx.rsrc are non-trivial. OPTIONS
The following options are supported: -a filename Specify the full path of the access control file used by the Master Agent. The default access control file is /etc/snmp/conf/snmpdx.acl. -c config-dir Specify the full path of the directory containing the Master Agent configuration files. The default directory is /etc/snmp/conf. -d debug-level Debug. Levels from 0 to 4 are supported, giving various levels of debug information. The default is 0 which means no debug information is given. -h Help. Print the command line usage. -i filename Specify the full path of the enterprise-name OID map. This file contains the PID used by the Master Agent for recovery after a crash. It contains tuples of the UNIX process ID, port number, resource name, and agent name. The default file is /var/snmp/snmpdx.st. -m GROUP | -m SPLIT Specify the mode to use for forwarding of SNMP requests. GROUP Multiple variables can be included in each request from the Master Agent to the subagents. This results in, at mose, one send-request per agent. SPLIT Each variable in the incoming request results in one send-request to each subagent. The default is GROUP. -o filename Specify the full path of the file containing the tuple (enterprise-name, OID). For example, (Sun Microsystems, 1.3.1.6.1.4.32). The Master Agent uses this file as a base for look-up in the trap-filtering and forwarding process. The default file is /etc/snmp/conf/enterprises.oid. -p port Specify the port number. The default port number is 161. -r filename Specify the full path of the resource file to be used by the Master Agent. This file stores information about the subagents that the Master Agent invokes and manages. The default resource file is /etc/snmp/conf/snmpdx.rsrc. -y Set a recovery indicator to invoke the recovery module. The recovery process discovers which subagents in the pre- vious session are still active; those subagents not active are re-spawned by the Master Agent. FILES
/etc/snmp/conf/enterprises.oid Enterprise-name OID map /etc/snmp/conf/snmpdx.acl Access control file /etc/snmp/conf/snmpdx.rsrc Resource configuration file /var/snmp/snmpdx.st Master Agent status file /var/snmp/mib/snmpdx.mib Master Agent MIB file EXIT STATUS
The following error values are returned: 0 Successful completion. non-zero An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWsasnm | +-----------------------------+-----------------------------+ SEE ALSO
snmpXdmid(1M), attributes(5) SunOS 5.10 17 Oct 2002 snmpdx(1M)
All times are GMT -4. The time now is 12:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy