09-16-2013
UNIX grouping
Hi guys,
I am a complete newbie to unix and have been tasked with creating a script to group the following data (file) by hourly slots so that I can count the transactions completed within the peak hour.
I am not sure how to group data like this in unix. Can anyone please help?
Here is an example of a line
13 Sep 2013 11:47:13,929 [user:11111,ip:xx.xx.xx.xx] Servicing GET request for /store/111/departments
based on this I need to group data over the 24 hour period 00-01, 02-02 etc and then count how many times the departments url was hit within that hour. Is this possible?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i am using the c shell on solaris.
directories i'm working with:
ls -1d DIV*
DIV_dental/
DIV_ibc/
DIV_ifc/
DIV_index/
DIV_pharm/
DIV_sectionI/
DIV_sectionI-title/
DIV_sectionI-toc/
DIV_sectionII-title/
DIV_sectionII-toc/
DIV_standing/
DIV_standing-toc/
DIV_title/
DIV_vision/ (1 Reply)
Discussion started by: effigy
1 Replies
2. Shell Programming and Scripting
Hi everyone,
I need a help on Unix scripting.
I have a file is like this
Date Amt
20071205 10
20071204 10
20071203 200
20071204 300
20071203 400
20071205 140
20071203 100
20071205 100... (1 Reply)
Discussion started by: pcharanraj
1 Replies
3. UNIX for Advanced & Expert Users
I am new to the unix server.
My question is:
i have 10 users
a
b
c
d
e
f
g
h
i
j
Among the 10 5 users are (normal) user and remainging 5 users are (qad) users
How can i sepearte this one?
How can i give the dlc access rights?
Please provide the clear cut idea. (0 Replies)
Discussion started by: kingganesh04
0 Replies
4. Shell Programming and Scripting
I have file like this
d123, rahim, 140
d123, rahul, 440
d123, begum, 340
d234, bajaj, 755
d234, gajal, 657
I want to group this file like this
d123, rahim, 140
rahul, 440
begum, 340
d234, bajaj, 755
gajal, 657
can any one help me on this
thanks in advance (8 Replies)
Discussion started by: trichyselva
8 Replies
5. Shell Programming and Scripting
Hello All,
I have a small problem with file group/splitting and I am trying to get the best way to perform this in unix. I am trying with awk but need some suggestion what would be the best and fastest way to-do it.
Here is the problem. I have a fixed length file with filled with product... (4 Replies)
Discussion started by: nandhan11891
4 Replies
6. Shell Programming and Scripting
Hi,
I am looking for a way to Group the Lines in a file.. Basically My file structure is something like this
A 1 100 abc def
A 1 200 abc def
A 1 300 abc def
A 2 100 pqr def
A 2 200 pqr def
A 2 300 pqr def
A 1 100 abc def
A 1 200 xyz def
A 1 300 xyz def
I need it as... (1 Reply)
Discussion started by: mkandula1983
1 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I am looking for a way to Group the Lines in a file.. Basically My file structure is something like this
A 1 100 abc def
A 1 200 abc def
A 1 300 abc def
A 2 100 pqr def
A 2 200 pqr def
A 2 300 pqr def
A 1 100 abc def
A 1 200 xyz def
A 1 300 xyz def
I need it as... (6 Replies)
Discussion started by: mkandula1983
6 Replies
8. Shell Programming and Scripting
Hi all,
I am using following command:
perl program.pl input.txt output.txt CUTOFF 3 > groups_3.txt
containing program.pl, two files (input.txt, output.txt) and getting output in groups_3.txt:
But, I wish to have 30 files corresponding to each CUTOFF ranging from 0 to 30 using the same... (1 Reply)
Discussion started by: bioinfo
1 Replies
9. Shell Programming and Scripting
awk 'FNR==NR {a; next} $NF in a' genes.txt refseq_exons.txt > output.txt
I can not figure out how to group the same name in $4 together.
Basically, all the SKI together in separate rows and all the TGFB2. Thank you :).
chr1 2160133 2161174 SKI
chr1 218518675 218520389 TGFB2... (1 Reply)
Discussion started by: cmccabe
1 Replies
10. Shell Programming and Scripting
Hello,
I would like to group/sort a file of records by a particular field and then count how many records belong in that grouping.
For example say I have the following data:
1234|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA
ABCD|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA
EFGH|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|BB... (14 Replies)
Discussion started by: Nik44
14 Replies
LEARN ABOUT DEBIAN
rt-email-dashboards-4
rt-email-dashboards(8) Request Tracker Reference rt-email-dashboards(8)
NAME
rt-email-dashboards - Send email dashboards
SYNOPSIS
rt-email-dashboards [options]
DESCRIPTION
This tool will send users email based on how they have subscribed to dashboards. A dashboard is a set of saved searches, the subscription
controls how often that dashboard is sent and how it's displayed.
Each subscription has an hour, and possibly day of week or day of month. These are taken to be in the user's timezone if available, UTC
otherwise.
SETUP
You'll need to have cron run this script every hour. Here's an example crontab entry to do this.
0 * * * * /usr/bin/perl /opt/rt4/local/sbin/rt-email-dashboards
This will run the script every hour on the hour. This may need some further tweaking to be run as the correct user.
OPTIONS
This tool supports a few options. Most are for debugging.
-h
--help Display this documentation
--dryrun
Figure out which dashboards would be sent, but don't actually generate or email any of them
--time SECONDS
Instead of using the current time to figure out which dashboards should be sent, use SECONDS (usually since midnight Jan 1st, 1970,
so 1192216018 would be Oct 12 19:06:58 GMT 2007).
--epoch SECONDS
Back-compat for --time SECONDS.
--all Ignore subscription frequency when considering each dashboard (should only be used with --dryrun for testing and debugging)
perl v5.14.2 2013-05-22 rt-email-dashboards(8)