Solved

Using VI  - This is an easy enough for for the GURUS

Posted on 2009-07-02
13
956 Views
Last Modified: 2013-12-13
Hi,

What is the command in vi to capture the line below with the IMSI value also.  I have a whole log full of these and I need to grep out the reject message with the IMSI associated with it?

======== MOBILITY EVENT (G): ATTACH REJECT =========
======== MOBILITY EVENT (G): ATTACH REJECT =========

Time      : 2009-06-17 20:01:47 

Node      : e_Erlang__Global_pm1_12_2_1@eqmffffffs0cp2

GMM Cause : Network Failure (#17)

Details   : Timeout when communicating with external node

Attach    : imsi_type, gprs_attach

IMSI      : 214567890890

PTMSI     : N/A

RA New    : 211_111005105

RA Old    : 211_0265532222

Cell ID   : 40434

HLR addr  : 00174034464646464646
 
 

======== MOBILITY EVENT (G): ATTACH REJECT =========

Time      : 2009-06-17 20:01:48 

Node      : e_Erlang__Global_pm1_11_2_1@eqm01s0bp2

GMM Cause : Network Failure (#17)

Details   : Timeout when communicating with external node

Attach    : imsi_type, gprs_attach

IMSI      : 23431023436593643402

PTMSI     : N/A

RA New    : 23434_0301025001

RA Old    : 23434_0365534001

Cell ID   : 27655

HLR addr  : 0017404478026593643400

Open in new window

0
Comment
Question by:columcusack
  • 7
  • 6
13 Comments
 
LVL 11

Expert Comment

by:techzter
ID: 24762523
Could you use grep to grab them and drop them into another file?

For instance

grep -e <keyword1> -e <keyword2> filename >> filename2

You could use IMSI and Mobility as keywords assuming that those are not used elsewhere in the file.
0
 
LVL 1

Author Comment

by:columcusack
ID: 24762940
OK.  Thanks for that.

Say I have 20 files called log1, log2, log3 etc etc etc

I need to capture the IMSI value from each reject message in each log file with the time value also?

Can you help with this?
0
 
LVL 11

Expert Comment

by:techzter
ID: 24762993
Are all of the files within the same directory? Are they the only files named log*? If so cd so that you are within that directory and run the command as

grep -e <keyword1> -e <keyword2> log* >> filename2

again us IMSI and MOBILITY as the keyword log* will grep all files that are named log with characters following it. Give the filename2 a name such as queryresults or something other than log.
0
 
LVL 1

Author Comment

by:columcusack
ID: 24763111
SunOS eqm01s14p2 5.9 Generic_118558-22 sun4u sparc SUNW,Netra-CP2300

I tried what you said and it fails each time, can you correct my error?


=== ageorge@eqm01s14p2 ANCB mobility_event_log/ready # grep -e REJECT -e IMSI mobility_event_log.* > colout.txt
grep: illegal option -- e
Usage: grep -hblcnsviw pattern file . . .
=== ageorge@eqm01s14p2 ANCB mobility_event_log/ready # grep -e REJECT -e IMSI mobility_event_log.* > colut.txt
grep: illegal option -- e
Usage: grep -hblcnsviw pattern file . . .
=== ageorge@eqm01s14p2 ANCB mobility_event_log/ready # grep -e < *REJECT* > -e < IMSI > mobility_event_log* >> colout.txt
Ambiguous input redirect.
=== ageorge@eqm01s14p2 ANCB mobility_event_log/ready #
0
 
LVL 11

Expert Comment

by:techzter
ID: 24763173
Could you paste the command exactly as you are entering it?
0
 
LVL 1

Author Comment

by:columcusack
ID: 24763181
grep -e REJECT -e IMSI mobility_event_log.* > colut.txt
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 11

Expert Comment

by:techzter
ID: 24763198
Oooh I just noticed from you output.. Is this a Solaris box? If so the commands parameters could be different than what is available on a Linux box.
0
 
LVL 1

Author Comment

by:columcusack
ID: 24763236
SunOS eqm01s14p2 5.9 Generic_118558-22 sun4u sparc SUNW,Netra-CP2300

That is correct?  Can you still help?

Regards

Colum
0
 
LVL 11

Accepted Solution

by:
techzter earned 500 total points
ID: 24763318
Sorry I should have noticed it from your Zone postings.

Try this and see if it works better.

egrep 'REJECT|IMSI' mobility_event_log.* >colut.txt
0
 
LVL 1

Author Comment

by:columcusack
ID: 24763457
ok, this is much better  :)

egrep 'REJECT|IMSI|Time' mobility_event_log.* > colout.txt

I'm just trying to include the TIME also....checking now, will let you know shortly...
0
 
LVL 1

Author Comment

by:columcusack
ID: 24763491
Thanks a lot :)  

Thats done it :)  
0
 
LVL 1

Author Closing Comment

by:columcusack
ID: 31599149
thanks a lot
0
 
LVL 11

Expert Comment

by:techzter
ID: 24763511
Great! Glad to hear it. Now you can figure out how to automate it to run with a rotational log and you won't have to ever manually do it again. ;)
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org (http://seleniumhq.org) Go to that link and select download selenium in the right hand columnThat will then direct you to their downlo…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now