pidstat2csv_multi.sh

#!/bin/bash
# pidstat2csv.sh: shell program to convert output from pidstat to *.csv usable for reports server
# pidstat command to be used: nohup pidstat -p `pidof YOUR_PROCESS_HERE` -u -d -r -h 10 720 >> /tmp/Perf_DPA_MySQL_DefaultPS.txt
# pidstat command to be used: nohup pidstat -p `pidof YOUR_PROCESS_HERE` -u -d -r -h 10 60 >> /tmp/Perf_DPA_Oracle_`hostname`.txt
# pidstat -p $(pidof ora_pmon_orcl) -p $(pidof ora_dbw0_orcl) -p $(pidof ora_lgwr_orcl) -p $(pidof ora_ckpt_orcl) -p $(pidof ora_smon_orcl) -p $(pidof ora_reco_orcl) -u -d -r -h 10 5
input_file=$1
tmp_file=${input_file%%.*}.tmp

# define usage function
usage(){
        echo "Usage: $0 filename"
        exit 1
}

# define is_file_exits function 
# $f -> store argument passed to the script
is_file_exits(){
        local f="$1"
        [[ -f "$f" ]] && return 0 || return 1
}
# invoke  usage
# call usage() function if filename not supplied
[[ $# -eq 0 ]] && usage


get_processes(){
#find all processes in the file, leave out process oracle
processes=$(awk '/^ [0-9]/' "$input_file" | awk '{if ($17!="oracle") print $17}' | sort -u)
}

split_to_files(){
local process=$1
split_output_txt_file=${input_file%%.*}_$process.txt
    grep "$1" "$input_file" > "$split_output_txt_file"
}

create_header(){
#create header in output csv
local process=$1
split_output_csv_file=${input_file%%.*}_$process.csv
echo -e "\"(PDH-CSV 4.0)\ (Central Daylight Time)(300)\",\"\\\\\\LINUX-01\\Process(*)\\$process\\UID\",\"\\\\\\LINUX-01\\Process(*)\\$process\\PID\",\"\\\\\\LINUX-01\\Process(*)\\$process\\%usr\",\"\\\\\\LINUX-01\\Process(*)\\$process\\%system\",\"\\\\\\LINUX-01\\Process(*)\\$process\\%guest\",\"\\\\\\LINUX-01\\Process(*)\\$process\\%CPU\",\"\\\\\\LINUX-01\\Process(*)\\$process\\CPU  minflt/s\",\"\\\\\\LINUX-01\\Process(*)\\$process\\majflt/s\",\"\\\\\\LINUX-01\\Process(*)\\$process\\VSZ\",\"\\\\\\LINUX-01\\Process(*)\\$process\\RSS\",\"\\\\\\LINUX-01\\Process(*)\\$process\\MEM\",\"\\\\\\LINUX-01\\Process(*)\\$process\\kB_rd/s\",\"\\\\\\LINUX-01\\Process(*)\\$process\\kB_wr/s\",\"\\\\\\LINUX-01\\Process(*)\\$process\\kB_ccwr/s\",\"\\\\\\LINUX-01\\Process(*)\\$process\\iodelay\",\"\\\\\\LINUX-01\\Process(*)\\$process\\Command\"" > "$split_output_csv_file"
}

convert_data(){
#convert data and put it in output csv

#remove all lines that do not begin with space followed by number
awk '/^ [0-9]/' "$1" > "$tmp_file"
#replace first space with quote "
sed -i 's/^ */"/' "$tmp_file"
#replace multiple spaces with ","
sed -i 's/ \+/","/g' "$tmp_file"
#add quote at the end
sed -i 's/$/"/g' "$tmp_file"
#convert time stamp
awk -F, '{gsub(/"/,"",$1 ); $1 = "\""strftime("%D %T.000",$1)"\""; print; }' "$tmp_file" > tmp; mv tmp "$tmp_file"
#replace spaces with ","
sed -i 's/" /",/g' "$tmp_file"
#append processed text to output file
cat "$tmp_file" >> "$split_output_csv_file"
#remove temp file
rm "$tmp_file"
}

# Invoke is_file_exits
if ( is_file_exits "$1" )
then
    echo -e "getting processes\n"
    get_processes
    for process in $processes; do
        split_to_files "$process"
	    create_header "$process"
        convert_data "$split_output_txt_file"
    done
else
 echo "File not found"
fi