Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Script (ksh) to get data in every 30 mins interval for the given date

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Script (ksh) to get data in every 30 mins interval for the given date
Prev   Next
# 1  
Old 10-04-2013
Lightbulb 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
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Script to search log file for last 15 mins data

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)
Discussion started by: mutley2202
6 Replies

2. UNIX for Dummies Questions & Answers

Extract only the data from ksh script running netezza query

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)
Discussion started by: maximus_jack
10 Replies

3. Shell Programming and Scripting

Run Bash Script thrice & then interval for 10 mins.

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)
Discussion started by: jeetz
4 Replies

4. Shell Programming and Scripting

AWK counting interval / histogram data

My data looks like this: frame phi psi 0 68.466774 -58.170494 1 75.128593 -51.646816 2 76.083946 -64.300102 3 77.578056 -76.464218 4 63.180199 -76.067680 5 77.203979 -58.560757 6 66.574913 -60.000214 7 73.218269 -70.978203 8 70.956879 -76.096558 9 65.538872 -76.716568... (19 Replies)
Discussion started by: chrisjorg
19 Replies

5. Shell Programming and Scripting

Averaging data every 30 mins using AWK

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)
Discussion started by: gd9629
18 Replies

6. Shell Programming and Scripting

KSH Script -- loop and data copy question

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)
Discussion started by: hurtzdonut
2 Replies

7. Shell Programming and Scripting

How to Get 60 days Old date from current date in KSH script

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)
Discussion started by: Himanshu_soni
3 Replies

8. Shell Programming and Scripting

Need Help for interval date

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)
Discussion started by: giofai
4 Replies

9. Shell Programming and Scripting

To extract data of a perticular interval (date-time wise)

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)
Discussion started by: abhishek27
3 Replies

10. Shell Programming and Scripting

Parsing and getting data from XML file using ksh script

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)
Discussion started by: vinna
6 Replies
Login or Register to Ask a Question