Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Extracting logs using gunzip awk and gzip

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extracting logs using gunzip awk and gzip
# 8  
Old 05-11-2016
Plus, when doing a "string comparison", be aware that e.g. "05/26/2014" is greater than "04/26/2015" which might not be what you expect.
# 9  
Old 05-11-2016
Quote:
Originally Posted by Don Cragun
In addition to what RudiC has already suggested, you also need to realize that a string in the format you are prompting for (YYYYMMDD) is not going to work well to compare against a string in the format MM/DD/YYYY which is what you said works with your existing pipeline.

And that if the pipeline matching against [04/26/2016][03:30:00.000] (note that there is no space in this pattern) works, then a command that puts a space between the expansion of the Date and Time variables (as in
Code:
gunzip -c "$file_"*.gz | awk '$0 > "$Date $Time" && $0 < "$Date $Time"' | gzip >> "$location" &"

can't work). And, furthermore, if you are reading a variable named date, you need to reference the contents of that variable using $date (NOT $Date).

Hi Sir
The Variable are working properly and are taking what is being shared by the user in input (Tried echo its fetching correct values).
so Date and Time is not the issue here.


I agree ' " can be a issue but I have tried a lot but not able to figure out how to use it.



I have shared the awk command above can you create a UI based script I can try?
# 10  
Old 06-30-2016
Hi Kindly find the code written below:


Code:
 
 #!/usr/ssh/bin
# My first script
 echo -n "Enter Start Date in Format YYYYMMDD:"
read date
echo "You Entered : $date"
 echo -n "Enter Start Date in Format MM/DD/YYYY:"
read date1
echo "You Entered : $date1"
 echo -n "Enter END Date in Format YYYYMMDD:"
read date2
echo "You Entered : $date2"
 echo -n "Enter END Date in Format MM/DD/YYYY:"
read date3
echo "You Entered : $date3"
 echo -n "Enter Start Time in Format HH:MM:SS.SSS eg. 03:30:00.000 :"
read time
echo "You Entered : $time"
 echo -n "Enter End Time in Format HH:MM:SS.SSS eg. 05:29:59.999 :"
read time1
echo "You Entered : $time1"
 echo -n "Enter Path Where you want to save the Logs :"
read Path
echo "You Entered : $Path"
 initial=[$date1][$time]
 echo $initial
 final=[$date3][$time1]
 echo $final
 
location=$Path/smtracedefault_$server.log.gz
 
#ssh <server1>  "nohup  gunzip -c $file*.gz | awk '$0 > "'$initial'" && $0 < "'$final'"' | gzip >> $location &"
 #ssh <server2>  "nohup  gunzip -c $file*.gz | awk '$0 > "'$initial'" && $0 < "'$final'"' | gzip >> $location &"
 #ssh <server3>  "nohup  gunzip -c $file*.gz | awk '$0 > "'$initial'" && $0 < "'$final'"' | gzip >> $location &"
 #nohup gunzip -c $file*.gz | awk '$0 > "'$initial'" && $0 < "'$final'"' | gzip >> $location &


in this code


the last command works if I log into the server manually(not through script) where as I want to log in using script only.

Code:
#nohup gunzip -c $file*.gz | awk '$0 > "'$initial'" && $0 < "'$final'"' | gzip >> $location &


I am not able to use expect send and interact.Public and private keys cannot be placed on all servers.Userid and password cannot be hardcoded. SED does not work on the servers.


I want to logging into server and run the awk command working individually through script on all the required servers.

Please help.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

File name manipulation when extracting from gzip

Hi, Below is the description of my problem. I am trying to loop through the below file names sitting in the file - FileNames.txt, and trying to decompress them FileNames.txt 20150408_MGAC_.txt.gz 20150408_MGCC_.txt.gz 20150408_MGSH__.txt.gz 20150408_MGSL__.txt.gz ... (6 Replies)
Discussion started by: Richmond_CS
6 Replies

2. UNIX for Dummies Questions & Answers

help in extracting logs in readable format

hello everyone. newbie here in unix. I am trying to extract the logs of a certain job and would like to output it in a readable format, see below the CAT part: cat /var/opt/ctma/ctm/sysout/idwesct_sh30_eng_r6_cdcs_sh.LOG_05l0du_000* | egrep -i 'orderid:|file_name=' | sed... (1 Reply)
Discussion started by: eanne_may
1 Replies

3. UNIX for Dummies Questions & Answers

gzip to read logs

Ok here is my trouble. I run scripts whenever I am investigating problems. One of those scripts simply goes to a log folder and runs gzip -cd * | grep error | wc -l This tells me the number of errors in their log's and how much I should pay attention to them. The problem is sometimes... (3 Replies)
Discussion started by: MrEddy
3 Replies

4. UNIX for Dummies Questions & Answers

gzip-gunzip a problem

Hi all, i have a gzipped file. <file_name>.gz . when i try gunzip this file i get, invalid compressed data--format violated this file gzipped like gzip -f -S <file_name> 2 > <error_log_file> there is no error in log. it seems that the file gzipped properly. how this ... (3 Replies)
Discussion started by: dummydba
3 Replies

5. Shell Programming and Scripting

Awk Help for extracting report from logs

Hi I have a log file, with lines of following kind. ------------------------ 2009-05-15 07:49:42,574 INFO - SqlMapObjectDataDao - select - selectObject - 2 ms 2009-05-15 07:49:42,575 INFO - SqlMapUserDao - select - getUserSystemAdminSuperGroup - 0 ms 2009-05-15 07:49:42,576 INFO -... (3 Replies)
Discussion started by: jitendriya.dash
3 Replies

6. Solaris

doubt reg gzip,gunzip

Hi, Can anyone let me explain the difference between tar , uncompress,gzip and gunzip commands. both gzip and gunzip are same i think correct me if am wrong. (1 Reply)
Discussion started by: rogerben
1 Replies

7. UNIX for Dummies Questions & Answers

Cloning OracleHome (gzip/gunzip Help)

Environment: ServerA - IBM AIX 5.2 ServerB - IBM AIX 5.2 I want to clone one of my oracle installation. The easiest way is to ZIP(possibly use gzip) the installed folder from the ServerA (Here Oracle is installed and working fine) , FTP to the ServerB(Here I want to have the installation... (4 Replies)
Discussion started by: aixhp
4 Replies

8. UNIX for Dummies Questions & Answers

gunzip error - not in gzip format

Hi, I am getting this error gunzip file1.tar.Z gunzip: file1.tar.Z: not in gzip format Any clues? This goes bad only in some recent installations of ids (5 Replies)
Discussion started by: eagercyber
5 Replies

9. Shell Programming and Scripting

Extracting data from large logs.

Hi all, I have a large log file that gets created daily. I need to be able to pull text out of the log when I hit a pattern including the 7 lines above it and the 3 lines below and output it to a new text file. Line 1 Line 2 Line 3 Line 4 Line 5 Line 6 Line 7 Pattern Line 9 Line 10... (11 Replies)
Discussion started by: bas
11 Replies

10. HP-UX

decompress in HPUX11 by Gunzip and gzip

Hello evrebody , I have HPUX-11, i try to install "Mozilla" and "unzip utillity" I cannot decompress file (F.tar.gz) or file(F.gz) by commandes: gunzip -dv F.tar.gz | tar -xvf gunzip F.tar.gz or gzip -dv F.tar.gz |tar -xvf gzip F.gz maybe someone know What's the reason? maybe i... (1 Reply)
Discussion started by: yanly64
1 Replies
Login or Register to Ask a Question