|
|
Script (ksh) to get data in every 30 mins interval for the given date
10-04-2013
Script (ksh) to get data in every 30 mins interval for the given date
10-04-2013
10-04-2013
10-04-2013
#!/bin/ksh
printf "Enter the date (YYYY/MM/DD): "
read dd
awk -F '[ :]' -v dd="$dd" '
BEGIN { fmt = "Batches that were successful on %s between %02d:%02d:00 " \
"and %02d:%02d:59 : %d\n"
}
$1 == dd && $NF == "successful" { s[$2 + 0, $3 > 29]++ }
END { for(h = 0; h < 24; h++)
for(m = 0; m < 2; m++)
printf(fmt, dd, h, m * 30, h, m * 30 + 29, s[h, m])
}' logEnter the date (YYYY/MM/DD): 2013/03/07
Batches that were successful on 2013/03/07 between 00:00:00 and 00:29:59 : 0
Batches that were successful on 2013/03/07 between 00:30:00 and 00:59:59 : 0
Batches that were successful on 2013/03/07 between 01:00:00 and 01:29:59 : 2
Batches that were successful on 2013/03/07 between 01:30:00 and 01:59:59 : 1
Batches that were successful on 2013/03/07 between 02:00:00 and 02:29:59 : 1
Batches that were successful on 2013/03/07 between 02:30:00 and 02:59:59 : 0
Batches that were successful on 2013/03/07 between 03:00:00 and 03:29:59 : 0
Batches that were successful on 2013/03/07 between 03:30:00 and 03:59:59 : 0
Batches that were successful on 2013/03/07 between 04:00:00 and 04:29:59 : 0
Batches that were successful on 2013/03/07 between 04:30:00 and 04:59:59 : 0
Batches that were successful on 2013/03/07 between 05:00:00 and 05:29:59 : 1
Batches that were successful on 2013/03/07 between 05:30:00 and 05:59:59 : 1
Batches that were successful on 2013/03/07 between 06:00:00 and 06:29:59 : 0
Batches that were successful on 2013/03/07 between 06:30:00 and 06:59:59 : 1
Batches that were successful on 2013/03/07 between 07:00:00 and 07:29:59 : 0
Batches that were successful on 2013/03/07 between 07:30:00 and 07:59:59 : 0
Batches that were successful on 2013/03/07 between 08:00:00 and 08:29:59 : 1
Batches that were successful on 2013/03/07 between 08:30:00 and 08:59:59 : 0
Batches that were successful on 2013/03/07 between 09:00:00 and 09:29:59 : 0
Batches that were successful on 2013/03/07 between 09:30:00 and 09:59:59 : 0
Batches that were successful on 2013/03/07 between 10:00:00 and 10:29:59 : 2
Batches that were successful on 2013/03/07 between 10:30:00 and 10:59:59 : 2
Batches that were successful on 2013/03/07 between 11:00:00 and 11:29:59 : 1
Batches that were successful on 2013/03/07 between 11:30:00 and 11:59:59 : 0
Batches that were successful on 2013/03/07 between 12:00:00 and 12:29:59 : 0
Batches that were successful on 2013/03/07 between 12:30:00 and 12:59:59 : 1
Batches that were successful on 2013/03/07 between 13:00:00 and 13:29:59 : 1
Batches that were successful on 2013/03/07 between 13:30:00 and 13:59:59 : 1
Batches that were successful on 2013/03/07 between 14:00:00 and 14:29:59 : 3
Batches that were successful on 2013/03/07 between 14:30:00 and 14:59:59 : 2
Batches that were successful on 2013/03/07 between 15:00:00 and 15:29:59 : 2
Batches that were successful on 2013/03/07 between 15:30:00 and 15:59:59 : 3
Batches that were successful on 2013/03/07 between 16:00:00 and 16:29:59 : 3
Batches that were successful on 2013/03/07 between 16:30:00 and 16:59:59 : 2
Batches that were successful on 2013/03/07 between 17:00:00 and 17:29:59 : 2
Batches that were successful on 2013/03/07 between 17:30:00 and 17:59:59 : 2
Batches that were successful on 2013/03/07 between 18:00:00 and 18:29:59 : 3
Batches that were successful on 2013/03/07 between 18:30:00 and 18:59:59 : 0
Batches that were successful on 2013/03/07 between 19:00:00 and 19:29:59 : 3
Batches that were successful on 2013/03/07 between 19:30:00 and 19:59:59 : 5
Batches that were successful on 2013/03/07 between 20:00:00 and 20:29:59 : 1
Batches that were successful on 2013/03/07 between 20:30:00 and 20:59:59 : 0
Batches that were successful on 2013/03/07 between 21:00:00 and 21:29:59 : 3
Batches that were successful on 2013/03/07 between 21:30:00 and 21:59:59 : 3
Batches that were successful on 2013/03/07 between 22:00:00 and 22:29:59 : 0
Batches that were successful on 2013/03/07 between 22:30:00 and 22:59:59 : 2
Batches that were successful on 2013/03/07 between 23:00:00 and 23:29:59 : 1
Batches that were successful on 2013/03/07 between 23:30:00 and 23:59:59 : 1
Regrets for the typo...
10-04-2013
10-04-2013
#!/bin/ksh
printf "Enter the date (YYYY/MM/DD): "
read dd
awk -F '[ :]' -v dd="$dd" '
BEGIN { fmt = "Batches that were successful on %s between %02d:%02d:00 " \
"and %02d:%02d:59 : %d\n"
}
$1 == dd && $NF == "successful" { s[$2 + 0, $3 > 29]++ }
END { for(h = 0; h < 24; h++)
for(m = 0; m < 2; m++)
printf(fmt, dd, h, m * 30, h, m * 30 + 29, s[h, m])
}' logawk -v rd="2013/03/07" -v st="00:00:00" -v et="00:29:59" '$1==rd && $2>=st && $2<=et' log | grep -c "successful"
|
|
|
|