Script (ksh) to get data in every 30 mins interval for the given date
Hello,
Since I m new to shell, I had a hard time to sought out this problem.
I have a log file of a utility which tells that batch files are successful with timestamp. Given below is a part of the log file.
Code:
2013/03/07 00:13:50 [notice] Apache/1.3.29 (Unix) configured -- resuming normal operations
2013/03/07 00:23:50 [info] Server built: Feb 27 2004 13:56:37
2013/03/07 00:39:40 [notice] Accept mutex: sysvsem (Default: sysvsem)
2013/03/07 01:05:49 [info] [client 64.242.88.10] Batch 126 was successful
2013/03/07 01:15:19 [info] [client 64.242.88.10] Batch 272 was successful
2013/03/07 01:55:29 [info] [client 64.242.88.10] Batch 353 was successful
2013/03/07 02:05:09 [info] [client 64.242.88.10] Batch 241 was successful
2013/03/07 02:35:49 statistics: Use of uninitialized value in concatenation (.) or string at /home/httpd/twiki/lib/TWiki.pm line 528.
2013/03/07 04:45:41 statistics: Can't create file /home/httpd/twiki/data/Main/WebStatistics.txt - Permission denied
2013/03/07 05:05:49 [info] [client 64.242.88.10] Batch 671 was successful
2013/03/07 05:46:41 [info] [client 64.242.88.10] Batch 251 was successful
2013/03/07 06:35:26 [info] [client 64.242.88.10] Batch 181 was successful
2013/03/07 08:05:49 [info] [client 64.242.88.10] Batch 389 was successful
2013/03/07 10:05:29 [info] [client 64.242.88.10] Batch 911 was successful
2013/03/07 10:13:42 [info] [client 64.242.88.10] Batch 681 was successful
2013/03/07 10:45:33 [info] [client 64.242.88.10] Batch 451 was successful
2013/03/07 10:49:51 [info] [client 64.242.88.10] Batch 675 was successful
2013/03/07 11:05:29 [info] [client 64.242.88.10] Batch 439 was successful
2013/03/07 12:55:19 [info] [client 64.242.88.10] Batch 678 was successful
2013/03/07 13:05:33 [info] [client 64.242.88.10] Batch 557 was successful
2013/03/07 13:47:12 [info] [client 64.242.88.10] Batch 881 was successful
2013/03/07 14:09:16 [info] [client 64.242.88.10] Batch 115 was successful
2013/03/07 14:15:31 [info] [client 64.242.88.10] Batch 612 was successful
2013/03/07 14:29:19 [info] [client 64.242.88.10] Batch 111 was successful
2013/03/07 14:35:50 [info] [client 64.242.88.10] Batch 971 was successful
2013/03/07 14:57:49 [info] [client 64.242.88.10] Batch 347 was successful
2013/03/07 15:19:55 [info] [client 64.242.88.10] Batch 824 was successful
2013/03/07 15:28:51 [info] [client 64.242.88.10] Batch 908 was successful
2013/03/07 15:31:44 [info] [client 64.242.88.10] Batch 113 was successful
2013/03/07 15:47:41 [info] [client 64.242.88.10] Batch 990 was successful
2013/03/07 15:57:41 [info] [client 64.242.88.10] Batch 290 was successful
2013/03/07 16:05:49 [info] [client 64.242.88.10] Batch 120 was successful
2013/03/07 16:22:18 [error] [client 24.70.56.49] File does not exist: /home/httpd/twiki/view/Main/WebHome
2013/03/07 16:25:39 [info] [client 64.242.88.10] Batch 150 was successful
2013/03/07 16:29:49 [info] [client 64.242.88.10] Batch 145 was successful
2013/03/07 16:47:41 [info] [client 64.242.88.10] Batch 131 was successful
2013/03/07 16:51:19 [info] [client 64.242.88.10] Batch 481 was successful
2013/03/07 17:01:42 [info] [client 64.242.88.10] Batch 676 was successful
2013/03/07 17:23:14 [info] [client 64.242.88.10] Batch 121 was successful
2013/03/07 17:37:12 [info] [client 64.242.88.10] Batch 439 was successful
2013/03/07 17:43:39 [info] [client 64.242.88.10] Batch 336 was successful
2013/03/07 18:21:42 [info] [client 64.242.88.10] Batch 772 was successful
2013/03/07 18:25:11 [info] [client 64.242.88.10] Batch 154 was successful
2013/03/07 18:26:26 [info] [client 64.242.88.10] Batch 189 was successful
2013/03/07 19:01:09 [info] [client 64.242.88.10] Batch 346 was successful
2013/03/07 19:11:28 [info] [client 64.242.88.10] Batch 678 was successful
2013/03/07 19:19:29 [info] [client 64.242.88.10] Batch 814 was successful
2013/03/07 19:31:41 [info] [client 64.242.88.10] Batch 114 was successful
2013/03/07 19:33:16 [info] [client 64.242.88.10] Batch 561 was successful
2013/03/07 19:41:19 [info] [client 64.242.88.10] Batch 881 was successful
2013/03/07 19:53:17 [info] [client 64.242.88.10] Batch 445 was successful
2013/03/07 19:57:49 [info] [client 64.242.88.10] Batch 321 was successful
2013/03/07 20:01:56 [info] [client 64.242.88.10] Batch 890 was successful
2013/03/07 21:11:17 [info] [client 64.242.88.10] Batch 665 was successful
2013/03/07 21:19:55 [info] [client 64.242.88.10] Batch 340 was successful
2013/03/07 21:29:29 [info] [client 64.242.88.10] Batch 149 was successful
2013/03/07 21:31:49 [info] [client 64.242.88.10] Batch 213 was successful
2013/03/07 21:43:19 [info] [client 64.242.88.10] Batch 522 was successful
2013/03/07 21:49:46 [info] [client 64.242.88.10] Batch 450 was successful
2013/03/07 22:37:31 [info] [client 64.242.88.10] Batch 661 was successful
2013/03/07 22:39:11 [info] [client 64.242.88.10] Batch 542 was successful
2013/03/07 23:05:49 [info] [client 64.242.88.10] Batch 598 was successful
2013/03/07 23:41:14 [info] [client 64.242.88.10] Batch 811 was successful
2013/03/07 24:12:42 [info] [client 64.242.88.10] Batch 429 was successful
2013/03/07 24:22:09 [info] [client 64.242.88.10] Batch 238 was successful
2013/03/07 24:29:01 [info] [client 64.242.88.10] Batch 987 was successful
2013/03/07 24:44:43 [info] [client 64.242.88.10] Batch 144 was successful
.
.
.
2013/03/08 ------------------------------
2013/03/09 ------------------------------
2013/03/10 ------------------------------
Kindly help me with a ksh to get data from this log file in 30 minutes interval i.e for the given date in every 30 mins interval I need how many batches
were successful.
Desired output:
Code:
Enter the date:
2013/03/07
Batches that were successful on 2013/03/07 between 00:00:00 and 00:29:59 : 4
Batches that were successful on 2013/03/07 between 00:30:00 and 00:59:59 : 2
.
.
.
.
.
Batches that were successful on 2013/03/07 between 23:29:59 and 23:59:59 :4
Last edited by Don Cragun; 10-04-2013 at 04:51 AM..
Reason: Fix ending CODE tag
Hi All,
I have a xml file for example as described below
<xml>
<address>
<street><street>
<address/>
<isbn>426728783932020308393930303</isbn>
<book>
<name>
</name>
</book>
.
.
.
</xml>
My problem is to get the isbn number from the above described file using ksh script. Could... (6 Replies)
I want a shell script which extract data from a log file which contains date and time-wise data and i need the data for a perticular interval of time...what can i do??? (3 Replies)
Hello,
I need help about a shell script
I have a text file with this fields:
2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an error.
2009/01/19 09:33:35: --> ---ORA-28817: PL/SQL function returned an... (4 Replies)
Hi i am writing a cron job.
so for it i need the 60 days old date form current date in variable.
Like today date is 27 jan 2011 then output value will be stote in variable in formet Nov 27.
i am using EST date, and tried lot of solution and see lot of post but it did not helpful for me. so... (3 Replies)
I am trying to write a script that will allow me to train others with commands that I run manually by only allowing the exact command before continuing onto the next set of commands. Here is where I come into an issue. I have changed the directories for this post.
Software we run creates files... (2 Replies)
A happy Monday to you all,
I have a .csv file which contains data taken every 5 seconds. I want to average these 5 second data points into 30 minute averages!
date co2
25/06/2011 08:04 8.31
25/06/2011 08:04 8.32
25/06/2011 08:04 8.33... (18 Replies)
Hi...
I am very new to shell scripting. I have written a script with help of this forum and some googling and it works the way I want it to. Currently this script checks for my SIP trunk registration every 5 seconds, if registration is not available then it reboots my router through telnet... (4 Replies)
Hi
I searched this forum before posting the question, but couldnt find it, the issue
i'm facing is, i'm trying to select a column from a netezza table from a korn
shell script, but the query runs
var=$(nzodbcsql -q "select MAX(millcount) from table1";)
echo $var
it returns the value like... (10 Replies)
Hi All,
I have an issue which I'm trying to understand a way of doing, I have several nodes which contain syslog events which I want to force trigger an email initially (eventually leading to another method of alerting but to start with an email).
Basically the syslog file will have hours worth... (6 Replies)