How to extract log data based on current date and month ? Post: 302452826

Sponsored Content

Top Forums Shell Programming and Scripting How to extract log data based on current date and month ? Post 302452826 by superHonda123 on Monday 13th of September 2010 07:30:18 AM

09-13-2010

Registered User

How to extract log data based on current date and month ?

Hi Gurus,

I'm using HP-UX B.11.23 operating system.

I've been trying to extract this log info based on the current date and month, but was having some issues as the date column which on the 4th column has a comma and the 5th column has a dot tied to it.

Here is the output from my shut down log info.

Code:

cat /etc/shutdownlog | tail -10

13:36  Sun Dec 8, 2009.  Reboot:  (by root)
13:56  Sun Dec 10, 2009.  Halt:  (by root)
15:12  Sun Dec 27, 2009.  Reboot:  (by root)
13:46  Sun Apr 1, 2010.  Halt:
14:43  Sun Apr 8, 2010.  Halt:
17:28  Sun Apr 18, 2010.  Reboot:  (by root)
18:15  Thu Jul  1, 2010.  Reboot:  (by  root)
12:01  Mon Aug 30, 2010.  Reboot:  (by root)

Previously, I got some help some Gurus in this forum to use this type of AWK as a function module. Please see below.

AWKDATEMTH() {
awk -v v1=`date +'%h'` -v v2=`date +'%d'` -v v3=`awk '{print $4}' | tr -d ','` '$3==v1 && v3==v2'}

However, I've been trying to fix it to cater for my new log data, but was to no luck. Guess my scripting level is limited.

Appreciate for any of your help and advice.

Thank you in advance.

Cheers.

superHonda123

View Public Profile for superHonda123

Find all posts by superHonda123

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to find the create time of a file if current date is in next month

Hi All, I want to find the time diffrence between currnt time and "abc.txt" file create time. I have solve that but if the abc.txt file created last month then is there any process to find the difftent? Exp: Create time of abc.txt is "Apr 14 06:48" and currect date is "May 17 23:47"....

2. UNIX for Dummies Questions & Answers

print previous month (current month minus 1) with Solaris date and ksh

Hi folks month=`date +%m`gives current month Howto print previous month (current month minus 1) with Solaris date and ksh

3. Shell Programming and Scripting

How to extract log data based on date

Hi Gurus, I've been having some problem in extracting the log data based on the current date and month. As shown in the sample data below, how to extract the log info for Aug 11? Sample data: root pts/ta userpc Wed Aug 11 09:46 - 20:21 (10:35) root pts/ta userpc...

4. Shell Programming and Scripting

How to extract log info based on last month?

Hi Gurus I'm using HPUX B.11.23 ia64, the below sample log data was extracted from HPUX commnad: last -R. Sample data: root pts/ta userpc Wed Aug 11 09:46 - 20:21 (10:35) root pts/ta userpc Wed Aug 11 09:44 - 20:10 (10:34) root pts/ta userpc Wed Aug 11...

5. Shell Programming and Scripting

current date - one month in AIX

Hi, i unable to get the last month date in AIX. current date - one month Based on the forums tried but did not find the relevent information. Any help grealy appriciated. Thanks Suri.

6. Shell Programming and Scripting

Help with getting last date of previous month and first date of previous 4th month from current date

I have requirment to get last date of previous month and the first date of previous 4th month: Example: Current date: 20130320 (yyyymmdd) Last date of previous month: 20130228 (yyyymmdd) First date of previous 4th month: 20121101 (yyyymmdd) In my shell --date, -d, -v switches are not...

7. UNIX for Dummies Questions & Answers

Extract date ranged data from log file

Hi, I am trying to extract lines of data within a log file on a Redhat 5 Linux system. eg I need all the lines with a particular username over the last 3 minutes. the log file may read like this, and I want a way to search all the lines extracting all the relevant lines over the last 3...

8. AIX

AIX - Get next month from current date

As said in object, how can i obtain that? In linux i use date -d "1 month" +"%m%Y". Thanks i advance.

9. Homework & Coursework Questions

How to minus 2 month from current date?

I am running a script in ksh to get the 2 months back date from system date.The below code is giving correct date output from putty command prompt.But while running the script is .ksh file it is giving the error below.Please suggest. ; d=a; y=a m-=num while(m < 1) {m+=12; y--}...

10. UNIX for Beginners Questions & Answers

How to get first & last day of a month from current date?

Hi, I need the first & last day of a month from any given date. For better understanding, if i need to back-fill data for date 07/20/2019 i.e July 20 2019, i need the first & last day has 07/01/2019 - 07/31/2019. FYI: I'm using GIT BASH terminal. sample code: export DT=$(date --date='6 days...

LEARN ABOUT MINIX

reboot

REBOOT(8)						      System Manager's Manual							 REBOOT(8)

NAME

       reboot - reboot the system immediately

SYNOPSIS

       reboot [-f]

DESCRIPTION

       Reboot  can  be	used  to  reboot  the  system  after  installing a new kernel.	It does not inform the users, but does log it's actions in
       /usr/adm/wtmp and /usr/adm/authlog.  The system is then rebooted with the reboot(2) systemcall.

       If the -f flag is not given then all processes are sent terminate signals to give them a chance to die peacefully before the reboot() call.

       If the wtmp file exists, reboot logs itself as if it were a shutdown.  This is done to prevent last(1) from talking  about  system-crashes.
       Reboot is registered as is in the authlog file.

       Reboot can only be executed by the super-user.  Any other caller will be refused, either by reboot(8) or by reboot(2).

SEE ALSO

       reboot(2), shutdown(8), halt(8), boot(8).

BUGS

       The  error message's given by reboot are not always useful.  There are several routines that can fail, but which are not fatal for the pro-
       gram.

AUTHOR

       Edvard Tuinder (v892231@si.hhs.NL)

																	 REBOOT(8)