Shell Programming and Scripting

0 0 * * * /scripts/collect_cpu.sh
0 * * * * /scripts/process_cpu.sh

#!/bin/bash

sar -u 300 288 >> /var/log/mylogs/$(date "+%Y-%m-%d")_$(hostname)_cpuusage.log

#!/bin/bash

# Change directory to HNP logs
cd /var/log/mylogs/

# Loop over each file
for logFile in *_cpuusage.log
  do
    awk '
      BEGIN { OFS = "," } FNR == 1 {
        split(FILENAME,F,/_/)
        d=F[1]
        h=F[2]
      }
      $2 ~ /^[AP]M$/ && $3 != "CPU" {
        split($1, HMS, /:/)
	if(HMS[1] == 12)HMS[1] = 0
	if($2 == "PM")	HMS[1] += 12
	t = sprintf("%02d:%s:%s", HMS[1], HMS[2], HMS[3])
        print d, t, h, $4+$5, $6, $7+$8+$9
      }
    ' $logFile > /var/log/mylogs/$logFile.processed

  # load into mysql
  mysql -e "load data local infile '"$logFile.processed"' into table cpuusage fields TERMINATED BY ',' (hidden)

  # rename file done
  mv $logFile.processed $logFile.processed.done

  # mark .done for previous days
  if d < $(date "+%Y-%m-%d")
    mv $logFile $logFile.done
  endif

done

  # mark .done for previous days
  if d < $(date "+%Y-%m-%d")
    mv $logFile $logFile.done
  endif

sar -u 300 12 > ($date '+%H.log')