Help with tail /grep needed Post: 302117996

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Help with tail /grep needed Post 302117996 by Felix2511 on Thursday 17th of May 2007 02:29:52 PM

05-17-2007

Registered User

INPUT lOG:-> this is the file i want to serach -> string to search Smilie

atabase Connection Information

Database Connection Information

Database server =
SQL authorization ID =
Local database alias =

Number of rows read = 18724
Number of rows skipped = 0
Number of rows loaded = 18724
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 18724
DB20000I The RUNSTATS command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
B20000I The RUNSTATS command completed successfully.

Database Connection Information

Database server =
SQL authorization ID =
Local database alias =
Number of rows read = 18724
Number of rows skipped = 0
Number of rows loaded = 18724
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 18724
DB20000I The RUNSTATS command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The RUNSTATS command completed successfully.
---------- --------------- -------------- ------------- -------------
The Output file i want to have is only the first part of it beginning from the buttom:
Database Connection Information

Database server =
SQL authorization ID =
Local database alias =
Number of rows read = 18724
Number of rows skipped = 0
Number of rows loaded = 18724
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 18724
DB20000I The RUNSTATS command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The RUNSTATS command completed successfully.

Thank you.

Felix2511

View Public Profile for Felix2511

Find all posts by Felix2511

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

tail, grep and cut

Hello all, I have some weird problem that kinda baffles me. Say I have the following test file: claudia:~/tmp$ cat testfile.txt This is a test line This is the second test line And yeah, this is the third test line Then say I want to tail the file, grep for the word "third" then...

2. Shell Programming and Scripting

tail | grep lagging badly

I'm trying to use tail/grep to monitor a log file. The command I cooked up is: tail -n 50 -f output.log | grep 'type:system' | cut -f 5- A sample line from the log file is: 1208894862 type:system session:0 severity:4 load started the columns are tab delimited. this works ok, except...

3. Shell Programming and Scripting

Grep or Tail in shell script

Hi, I am writing a shell script that checks catalina logs on a production system and mails me if it detects errors. It greps the logs for known errors which i have defined as variables. The problem is the logs are huge, approx 30,000 before they rotate. So I am forced to use grep instead...

4. Shell Programming and Scripting

tail | grep

The program that is running on my machine generates log files. I want to be able to know the number of lines that contain "FT" in the most recent log file. I wrote the following, but it always returns zero. And I know the count is not zero. Any ideas? ls -rt *.log | tail -n 1 | grep -c FT

5. UNIX for Dummies Questions & Answers

Need help with a tail and a grep

I need to tail -f a file so I can monitor it as it is being written to. However, there is a lot of garbage in the file that I don't care about. So normally I would just pipe and grep for the string that is important to me. However, in this case, there are two things I need to grep for. I can't...

6. UNIX for Dummies Questions & Answers

mulitple grep using tail

I have a basic tail/grep question. I have logs that are generated & kept in a directory called alert_audit. I am using "tail" to see the logs that are coming in, but I only need logs that contain the IP address 10.249.185. or 10.247.231. Here is the command I have, but it pulls all IP...

7. UNIX for Dummies Questions & Answers

Write to file using tail -f through a pipe to grep

Hi -- I'm looking to write to a file after piping output from tail -f through to grep: #write to a file for all lines with "searchtext" within in error_log: Expand|Select|Wrap|Line Numbers tail -f /var/error_log | grep searchtext > output.txt The above command...

8. Shell Programming and Scripting

How do i use tail & grep in real time here??

Hi I have a file which is updated very frequently. Where in i wanted to use tail -f command in the script and wanted to grep for a particular word. But the issue is when i use tail -f filename|grep "word" ... it will show me blank until the word is found in the real time. if it shows...

9. UNIX for Dummies Questions & Answers

Tail -f | grep > output.txt

hi guys, I perform a sort of monitoring. I have a server running and with tail -f | grep "Searchstring"I monitor the log-file for recent specific entries. This is ok and works fine. Now, in addition I want to have my search results not posted into the shell but into a file. I tried: tail...

10. Shell Programming and Scripting

Trouble with tail and grep

Good Morning, i ran into some trouble this morning while 'improving' my monitoring stuff. i would like to get a warning when the number of mails sent (outbound) by postfix is above a certain number. so far, so easy. to test that i simply put cat /var/log/mail.info | grep 'to=<' | grep -v -e...

LEARN ABOUT PHP

sqlite_num_rows

SQLITE_NUM_ROWS(3)														SQLITE_NUM_ROWS(3)

sqlite_num_rows - Returns the number of rows in a buffered result set

SYNOPSIS

       int sqlite_num_rows (resource  $result)

DESCRIPTION

       Object oriented style (method):
       int SQLiteResult::numRows (void	)

	Returns the number of rows in the buffered $result set.

PARAMETERS

	      o $result
		- The SQLite result resource. This parameter is not required when using the object-oriented method.

	      Note

		     This function cannot be used with unbuffered result handles.

RETURN VALUES

	Returns the number of rows, as an integer.

EXAMPLES

       Example #1

	      Procedural example

	      <?php
	      $db = sqlite_open('mysqlitedb');
	      $result = sqlite_query($db, "SELECT * FROM mytable WHERE name='John Doe'");
	      $rows = sqlite_num_rows($result);

	      echo "Number of rows: $rows";
	      ?>

       Example #2

	      Object-oriented example

	      <?php
	      $db = new SQLiteDatabase('mysqlitedb');
	      $result = $db->query("SELECT * FROM mytable WHERE name='John Doe'");
	      $rows = $result->numRows();

	      echo "Number of rows: $rows";
	      ?>

SEE ALSO

       sqlite_changes(3), sqlite_query(3), sqlite_num_fields(3).

PHP Documentation Group 													SQLITE_NUM_ROWS(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

tail, grep and cut

Discussion started by: sylaan

2. Shell Programming and Scripting

tail | grep lagging badly

Discussion started by: WasabiVengeance

3. Shell Programming and Scripting

Grep or Tail in shell script

Discussion started by: Moxy

4. Shell Programming and Scripting

tail | grep

Discussion started by: sdilucca