Script to parse a file faster Post: 302551271

Sponsored Content

Top Forums Shell Programming and Scripting Script to parse a file faster Post 302551271 by sags007_99 on Tuesday 30th of August 2011 01:18:15 AM

08-30-2011

Registered User

Code:

[26/Aug/2011:11:24:20 +0000] conn=9978792 op=1 msgId=2 - SRCH base="ou=people,dc=abc,dc=com" scope=1 filter="(&(objectClass=shadowAccount)(uid=oracle))" attrs="uid userPassword shadowLastChange shadowMax shadowMin shadowWarning shadowInactive shadowExpire shadowFlag"
[26/Aug/2011:11:24:21 +0000] conn=9978793 op=1 msgId=2 - SRCH base="ou=people,dc=abc,dc=com" scope=1 filter="(&(objectClass=shadowAccount)(uid=oracle))" attrs="uid userPassword shadowLastChange shadowMax shadowMin shadowWarning shadowInactive shadowExpire shadowFlag"
[26/Aug/2011:11:24:22 +0000] conn=9978794 op=1 msgId=2 - SRCH base="ou=people,dc=abc,dc=com" scope=1 filter="(&(objectClass=shadowAccount)(uid=oracle))" attrs="uid userPassword shadowLastChange shadowMax shadowMin shadowWarning shadowInactive shadowExpire shadowFlag"
[26/Aug/2011:11:24:23 +0000] conn=9978795 op=1 msgId=2 - SRCH base="ou=people,dc=abc,dc=com" scope=1 filter="(&(objectClass=shadowAccount)(uid=oracle))" attrs="uid userPassword shadowLastChange shadowMax shadowMin shadowWarning shadowInactive shadowExpire shadowFlag"
[26/Aug/2011:11:24:30 +0000] conn=9978802 op=1 msgId=2 - SRCH base="ou=people,dc=abc,dc=com" scope=1 filter="(&(objectClass=shadowAccount)(uid=oracle))" attrs="uid userPassword shadowLastChange shadowMax shadowMin shadowWarning shadowInactive shadowExpire shadowFlag"
[26/Aug/2011:11:24:21 +0000] conn=9978793 op=-1 msgId=-1 - fd=559 slot=559 LDAPS connection from 10.20.13.2:30999 to 10.183.7.45
[26/Aug/2011:11:24:21 +0000] conn=9978793 op=-1 msgId=-1 - SSL 256-bit AES-256
[26/Aug/2011:11:24:21 +0000] conn=9978793 op=0 msgId=1 - BIND dn="" method=128 version=3
[26/Aug/2011:11:24:21 +0000] conn=9978793 op=0 msgId=1 - RESULT err=0 tag=97 nentries=0 etime=0 dn=""
[26/Aug/2011:11:24:21 +0000] conn=9978793 op=1 msgId=2 - SRCH base="ou=people,dc=abc,dc=com" scope=1 filter="(&(objectClass=shadowAccount)(uid=oracle))" attrs="uid userPassword shadowLastChange shadowMax shadowMin shadowWarning shadowInactive shadowExpire shadowFlag"
[26/Aug/2011:11:24:21 +0000] conn=9978793 op=1 msgId=2 - RESULT err=0 tag=101 nentries=1 etime=0
[26/Aug/2011:11:24:22 +0000] conn=9978793 op=2 msgId=0 - RESULT err=80 tag=120 nentries=0 etime=0
[26/Aug/2011:11:24:22 +0000] conn=9978793 op=-1 msgId=-1 - closing from 10.104.15.2:30988 - A1 - Client aborted connection -

Now to modify the script given by you for the file mentioned above, do I make it this:

Code:

#!/usr/bin/ksh  awk '     /uid=oracle/ { split( $3, a, "=" ); uids[a[2]] = 1; next; }     /connection from/ {         split( $3, a, "=" );         if( uids[a[2]] )             printf( "connid=%s IP=%s\n", a[2],  $(NF-2) );     } ' input-file-name

Last edited by pludi; 08-30-2011 at 06:59 PM..

sags007_99

View Public Profile for sags007_99

Find all posts by sags007_99

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help!!! Shell script to parse data file.

I am faced with a :confused: tricky problem to parse a data file ( May not be a tricky problem to the scripting guru's ). Here is what I am faced with. I have a file with multiple rows of data and the rows are not of fixed length. "|" is used as a delimiters for individual columns and each row...

2. UNIX for Advanced & Expert Users

shell script to parse html file

hi all, i have a html file something similar to this. <tr class="evenrow"> <td class="data">added</td><td class="data">xyz@abc.com</td> <td class="data">filename.sql</td><td class="modifications-data">08/25/2009 07:58:40</td><td class="data">Added TK prof script</td> </tr> <tr...

3. Shell Programming and Scripting

Parse XML file in shell script

Hi Everybody, I have an XML file containing some data and i want to extract it, but the specific issue in my file is that the data is repeated some times like the following example : <section1> <subsection1> X=... Y=... Z=... <\subsection1> <subsection2> X=... Y=... Z=......

4. Shell Programming and Scripting

Bash Shell Script to parse file

Raw Results: results|192.168.2|192.168.2.1|general/udp|10287|Security Note|For your information, here is the traceroute from 192.168.2.24 to 192.168.2.1 : \n192.168.2.24\n192.168.2.1\n\n results|192.168.2|192.168.2.1|ssh (22/tcp)|22964|Security Note|An SSH server is running on this port.\n...

5. UNIX for Dummies Questions & Answers

Help to parse csv file with shell script

Hello ! I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so... As said in the title, I want to read a csv file with a bash script. Here is a sample of the file: ...

6. Shell Programming and Scripting

script to parse the properties file

Hi Friends, I have a requirement to parse a properties file having a key=value pairs. i need to count the number of key value pairs in the properties file and iterate through each key-value pair. I have written the script to read the number of lines from the property file, but cannot...

7. Shell Programming and Scripting

Script to parse and update a parameter file

Dear All- My requirement is as below, need your inputs please 1] I have a file name Param.txt which contains the below data #GLOBAL# PARAM_VALUE=N ............. ............ CTRY=UK ......... 2] Next, I want to write a script which will check for some condition (lets assume...

8. Shell Programming and Scripting

Script to parse bookmarks file

I am using Internet Explorer v10 at work and regularly need to import my personal Firefox bookmarks over. Long story short, I have found the import falling over on any bookmark elements which are over 256 characters. The bookmark file contains bookmarks of this format: <DT><A...

9. Shell Programming and Scripting

Script parse file Linux

Hi all, I need help for a script that pulls out a series of numbers from a file (attached file) Basically I need a parse to write me in a variable: 9d424312 Can someone help me? Thank you

10. Homework & Coursework Questions

Script parse file

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: Hi all, I need help for a script that pulls out a series of numbers from a file (attached file) Basically I...

LEARN ABOUT PHP

cubrid_drop

CUBRID_DROP(3)								 1							    CUBRID_DROP(3)

cubrid_drop - Delete an instance using OID

SYNOPSIS

       bool cubrid_drop (resource  $conn_identifier, string  $oid)

DESCRIPTION

	The cubrid_drop(3) function is used to delete an instance from database by using the $oid of the instance.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

	      o $oid
		-Oid of the instance that you want to delete.

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_drop(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");

	      @cubrid_execute($conn, "DROP TABLE foo");
	      cubrid_execute($conn, "CREATE TABLE foo(a int AUTO_INCREMENT, b set(int), c list(int), d char(10))");
	      cubrid_execute($conn, "INSERT INTO foo(a, b, c, d) VALUES(1, {1,2,3}, {11,22,33,333}, 'a')");
	      cubrid_execute($conn, "INSERT INTO foo(a, b, c, d) VALUES(2, {4,5,7}, {44,55,66,666}, 'b')");

	      $req = cubrid_execute($conn, "SELECT * FROM foo", CUBRID_INCLUDE_OID);

	      cubrid_move_cursor($req, 1, CUBRID_CURSOR_FIRST);
	      $oid = cubrid_current_oid($req);

	      printf("--- Before Drop: ---
");
	      $attr = cubrid_get($conn, $oid);
	      var_dump($attr);

	      if (cubrid_drop($conn, $oid)) {
		  cubrid_commit($conn);
	      } else {
		  cubrid_rollback($conn);
	      }

	      cubrid_close_request($req);

	      $req = cubrid_execute($conn, "SELECT * FROM foo", CUBRID_INCLUDE_OID);

	      cubrid_move_cursor($req, 1, CUBRID_CURSOR_FIRST);
	      $oid = cubrid_current_oid($req);

	      printf("
--- After Drop: ---
");
	      $attr = cubrid_get($conn, $oid);
	      var_dump($attr);

	      cubrid_close_request($req);
	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      --- Before Drop: ---
	      array(4) {
		["a"]=>
		string(1) "1"
		["b"]=>
		array(3) {
		  [0]=>
		  string(1) "1"
		  [1]=>
		  string(1) "2"
		  [2]=>
		  string(1) "3"
		}
		["c"]=>
		array(4) {
		  [0]=>
		  string(2) "11"
		  [1]=>
		  string(2) "22"
		  [2]=>
		  string(2) "33"
		  [3]=>
		  string(3) "333"
		}
		["d"]=>
		string(10) "a	      "
	      }

	      --- After Drop: ---
	      array(4) {
		["a"]=>
		string(1) "2"
		["b"]=>
		array(3) {
		  [0]=>
		  string(1) "4"
		  [1]=>
		  string(1) "5"
		  [2]=>
		  string(1) "7"
		}
		["c"]=>
		array(4) {
		  [0]=>
		  string(2) "44"
		  [1]=>
		  string(2) "55"
		  [2]=>
		  string(2) "66"
		  [3]=>
		  string(3) "666"
		}
		["d"]=>
		string(10) "b	      "
	      }

SEE ALSO

       cubrid_is_instance(3).

PHP Documentation Group 													    CUBRID_DROP(3)