01-16-2008
Average Time
Hi Guys,
I am using a command
$ runprt_req PPGUS_ROYXN1102
Output:
**************** Start Date and Time End Date and Time***
PPGUS_ROYXN1102 01/15/2008 02:20:08 01/15/2008 04:54:50
PPGUS_ROYXN1102 01/12/2008 02:03:57 01/12/2008 04:22:10
PPGUS_ROYXN1102 01/11/2008 02:07:55 01/11/2008 04:28:54
PPGUS_ROYXN1102 01/10/2008 03:13:57 01/10/2008 04:52:24
I need to find the average time between Start and End Time
Ex: 02:20:08 - 04:54:50 So the average time is 02:34:02
Similarly i need the average time for the all the columns
Ex:
Start Time End Time Average Time
02:30 02:40 00:10
03:30 03:30 00:00
...........
I have a very big output, so its difficult to find the average time easily.
It will be helpfull for me, if i get a command or a script.
I tried using awk command, but i not much familiar with unix, so i didnt get any output except Syntax Error
Thanks in Advance.
10 More Discussions You Might Find Interesting
1. UNIX Desktop Questions & Answers
Hi,
I have MyLog.log file, and it contains "*** response Time 150",
I want to develop Unix script like ,
1. extract all such occurances in the MyLog.log file and
2. compute the average time taken
I am new to Unix, any one can give any idea/sample code for this?
Thanks in advance. (1 Reply)
Discussion started by: redlotus72
1 Replies
2. Shell Programming and Scripting
Hi all,
I have large daily log file(s) that hold the times for requests and responses on different system requests. What I want to do is work out average transaction times for the day (one log = one day).
The problem I'm having is figuring out how to skip rows, i've sorted the output by uniq... (2 Replies)
Discussion started by: nhatch
2 Replies
3. UNIX for Dummies Questions & Answers
I've been trying all night to come up with a script that will take a file that contains job completion times like this as input:
18:30
17:45
16:39
18:01
17:50
...
and figure the Average completion time. I've tried several things, and I just can't seem to get it to figure correctly. I'm... (5 Replies)
Discussion started by: Seawall
5 Replies
4. UNIX for Dummies Questions & Answers
Hi
I am looking for an awk script which can compute the average of the last column based on the date and time. The file looks:
site1,"2000-01-01 00:00:00", "2000-01-01 00:59:00",0.013
site2,"2000-02-01 01:00:00", "2000-02-01 01:59:00",0.035
site1,"2000-02-01 02:00:00", "2000-02-01... (15 Replies)
Discussion started by: kathy wang
15 Replies
5. UNIX for Dummies Questions & Answers
How can i determine the load average of a centos server for the last 1 hour? (3 Replies)
Discussion started by: proactiveaditya
3 Replies
6. Shell Programming and Scripting
Hello,
I'm hoping to get some help on calculating an average time from a list of times (hour:minute:second).
Here's what my list looks like right now, it will grow (I can get the full date or change the formatting of this as well):
07:55:31
09:42:00
08:09:02
09:15:23
09:27:45
09:49:26... (4 Replies)
Discussion started by: jaredhanks
4 Replies
7. Shell Programming and Scripting
Hello dears,
I have a log file with records like below and want to get a average of one column based on the search of one specific keyword.
2015-02-07 08:15:28 10.102.51.100 10.112.55.101 "kevin.c" POST ... (2 Replies)
Discussion started by: Newman
2 Replies
8. Shell Programming and Scripting
I want to get average idle time of the server using mpstat. The problem I am having is %idle is not in same columns in all the versions of linux.
example 1:
example 2:
I tried below command as generalized solution but as Average as one less column output is not proper.
I am... (1 Reply)
Discussion started by: kumarjohn
1 Replies
9. UNIX for Dummies Questions & Answers
Hello All ,
Please support for below request
how to change format and subtract time and date and get average.
xxx 13-OCT-15 11.32.18.241000 AM 13-OCT-15 11.35.49.089080 AM
xxx 13-OCT-15 11.32.24.000000 AM 13-OCT-15 11.45.17.810904 AM
xxx 13-OCT-15 11.32.25.232000 AM ... (1 Reply)
Discussion started by: mirwasim
1 Replies
10. UNIX for Beginners Questions & Answers
sorry i will revise first (1 Reply)
Discussion started by: fajar_3t3
1 Replies
LEARN ABOUT DEBIAN
getdate
GETDATE(1) User Commands GETDATE(1)
NAME
getdate - AME
SYNOPSIS
[-dv][-n dec][-f format] [ra dec sys] itype2otype [date and/or time]
DESCRIPTION
Convert date and time between various formats
[-dv][-n dec][-f format] itype2otype @file
itype: nfd=ISOFITS fd=FITS, dt=yyyy.mmdd, hr=hh:mm:ss, deg=dd:mm:ss
jd=Julian Date, mjd=Modified Julian Date hjd=Heliocentric Julian Date, mhjd=Modified HJD ep=epoch, epj=Julian epoch, epb=Besselian
epoch lt=local time, ut=UT, ts=seconds since 1950-01-01 now=current time, ang=fractional degrees
otype: fd=FITS, dt=yyyy.mmdd, jd=Julian Date, mjd=Modified Julian Date
hjd=Heliocentric Julian Date, mhjd=Modified HJD hr=hh:mm:ss, deg=dd:mm:ss, ang=fractional degrees ep=epoch, epj=Julian epoch,
epb=Besselian epoch ts=seconds since 1950-01-01, tsu=Unix sec, tsi=IRAF sec gst=Greenwich Sidereal Time, lst=Local Sidereal Time
@file: First one or two columns are in itype format ra dec sys: Need for Heliocentric conversions
-a: Append date to input file, if there is one
-d: Print date without time
-e: Print output as ET/TDT/TT converting from UT
-f: Format for output number (C printf)
-h hours: Longitude in hours, west positive
-l degrees: Longitude in degrees, west positive
-n: Number of decimal places in sec, epoch, JD
-t: Print time without date
-v: Verbose
getdate 3.8.4 June 2012 GETDATE(1)