Count per second on the log file
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
0
I have messages log file each line represents a cdr or transaction and that looks like:
2019-03-14 13:58:16,260 DEBUG xxxxxxxxxxxxxxxxxxxxxxxxx
i have to calculate transactions per second. which means number of cdrs (lines) per seconds and generate report contains time and number of transactions (lines) something like:
Time TPS
2019-03-14 13:58:16 102
linux shell-script shell
asked Mar 14 at 13:58
FshamriFshamri
1032
add a comment |
0
I have messages log file each line represents a cdr or transaction and that looks like:
2019-03-14 13:58:16,260 DEBUG xxxxxxxxxxxxxxxxxxxxxxxxx
i have to calculate transactions per second. which means number of cdrs (lines) per seconds and generate report contains time and number of transactions (lines) something like:
Time TPS
2019-03-14 13:58:16 102
linux shell-script shell
asked Mar 14 at 13:58
FshamriFshamri
1032
If that ',' is on every line, you could use:cut -d',' -f1 | uniq -c. If not, you should add other lines to the example input.
– ctx
Mar 14 at 14:24
example of each line :2019-03-14 00:07:01,688 DEBUG [org.mobicents.smsc.library.CdrGenerator] 2019-03-14 00:07:00,037 +0430,CCC,5,0,700566254,1,1,success,nsmsc_user,283308200,93702700006,412012105522548,null,Dear Customer, Only,
– Fshamri
Mar 14 at 14:27
add a comment |
0
0
0
I have messages log file each line represents a cdr or transaction and that looks like:
2019-03-14 13:58:16,260 DEBUG xxxxxxxxxxxxxxxxxxxxxxxxx
i have to calculate transactions per second. which means number of cdrs (lines) per seconds and generate report contains time and number of transactions (lines) something like:
Time TPS
2019-03-14 13:58:16 102
linux shell-script shell
asked Mar 14 at 13:58
FshamriFshamri
1032
I have messages log file each line represents a cdr or transaction and that looks like:
2019-03-14 13:58:16,260 DEBUG xxxxxxxxxxxxxxxxxxxxxxxxx
i have to calculate transactions per second. which means number of cdrs (lines) per seconds and generate report contains time and number of transactions (lines) something like:
Time TPS
2019-03-14 13:58:16 102
linux shell-script shell
linux shell-script shell
asked Mar 14 at 13:58
FshamriFshamri
1032
asked Mar 14 at 13:58
FshamriFshamri
1032
asked Mar 14 at 13:58
FshamriFshamri
1032
asked Mar 14 at 13:58
FshamriFshamri
1032
asked Mar 14 at 13:58
FshamriFshamri
1032
1032
If that ',' is on every line, you could use:cut -d',' -f1 | uniq -c. If not, you should add other lines to the example input.
– ctx
Mar 14 at 14:24
example of each line :2019-03-14 00:07:01,688 DEBUG [org.mobicents.smsc.library.CdrGenerator] 2019-03-14 00:07:00,037 +0430,CCC,5,0,700566254,1,1,success,nsmsc_user,283308200,93702700006,412012105522548,null,Dear Customer, Only,
– Fshamri
Mar 14 at 14:27
add a comment |
If that ',' is on every line, you could use:cut -d',' -f1 | uniq -c. If not, you should add other lines to the example input.
– ctx
Mar 14 at 14:24
example of each line :2019-03-14 00:07:01,688 DEBUG [org.mobicents.smsc.library.CdrGenerator] 2019-03-14 00:07:00,037 +0430,CCC,5,0,700566254,1,1,success,nsmsc_user,283308200,93702700006,412012105522548,null,Dear Customer, Only,
– Fshamri
Mar 14 at 14:27
If that ',' is on every line, you could use:
cut -d',' -f1 | uniq -c. If not, you should add other lines to the example input.– ctx
Mar 14 at 14:24
If that ',' is on every line, you could use:
cut -d',' -f1 | uniq -c. If not, you should add other lines to the example input.– ctx
Mar 14 at 14:24
example of each line :
2019-03-14 00:07:01,688 DEBUG [org.mobicents.smsc.library.CdrGenerator] 2019-03-14 00:07:00,037 +0430,CCC,5,0,700566254,1,1,success,nsmsc_user,283308200,93702700006,412012105522548,null,Dear Customer, Only ,– Fshamri
Mar 14 at 14:27
example of each line :
2019-03-14 00:07:01,688 DEBUG [org.mobicents.smsc.library.CdrGenerator] 2019-03-14 00:07:00,037 +0430,CCC,5,0,700566254,1,1,success,nsmsc_user,283308200,93702700006,412012105522548,null,Dear Customer, Only ,– Fshamri
Mar 14 at 14:27
add a comment |
1 Answer
1
active
oldest
votes
1
printf -- " Time TPSn"
sed 's/,.*//' < inputfile | # extract just the date-time
sort |
uniq -c | # field 1 is now the count of each line's occurrences
awk ' print $2, $3, $1 ' # rewrite as "date time count"
answered Mar 14 at 14:25
Mark PlotnickMark Plotnick
18.8k24169
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f506284%2fcount-per-second-on-the-log-file%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
printf -- " Time TPSn"
sed 's/,.*//' < inputfile | # extract just the date-time
sort |
uniq -c | # field 1 is now the count of each line's occurrences
awk ' print $2, $3, $1 ' # rewrite as "date time count"
answered Mar 14 at 14:25
Mark PlotnickMark Plotnick
18.8k24169
add a comment |
1
printf -- " Time TPSn"
sed 's/,.*//' < inputfile | # extract just the date-time
sort |
uniq -c | # field 1 is now the count of each line's occurrences
awk ' print $2, $3, $1 ' # rewrite as "date time count"
answered Mar 14 at 14:25
Mark PlotnickMark Plotnick
18.8k24169
add a comment |
1
1
1
printf -- " Time TPSn"
sed 's/,.*//' < inputfile | # extract just the date-time
sort |
uniq -c | # field 1 is now the count of each line's occurrences
awk ' print $2, $3, $1 ' # rewrite as "date time count"
answered Mar 14 at 14:25
Mark PlotnickMark Plotnick
18.8k24169
printf -- " Time TPSn"
sed 's/,.*//' < inputfile | # extract just the date-time
sort |
uniq -c | # field 1 is now the count of each line's occurrences
awk ' print $2, $3, $1 ' # rewrite as "date time count"
answered Mar 14 at 14:25
Mark PlotnickMark Plotnick
18.8k24169
edited Mar 14 at 14:32
answered Mar 14 at 14:25
Mark PlotnickMark Plotnick
18.8k24169
answered Mar 14 at 14:25
Mark PlotnickMark Plotnick
18.8k24169
answered Mar 14 at 14:25
Mark PlotnickMark Plotnick
18.8k24169
18.8k24169
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Unix & Linux Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f506284%2fcount-per-second-on-the-log-file%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If that ',' is on every line, you could use:
cut -d',' -f1 | uniq -c. If not, you should add other lines to the example input.– ctx
Mar 14 at 14:24
example of each line :
2019-03-14 00:07:01,688 DEBUG [org.mobicents.smsc.library.CdrGenerator] 2019-03-14 00:07:00,037 +0430,CCC,5,0,700566254,1,1,success,nsmsc_user,283308200,93702700006,412012105522548,null,Dear Customer, Only,– Fshamri
Mar 14 at 14:27