#!/bin/bash
#
# Script to collect the monthly "yum update" outputs on all servers listed on the command line.
# The script scp's the output of "yum update" from $file_dir (/var/tmp) on each of the servers
# (created using the "yum-check-updates.sh" script run on each machine every Monday via cron),
# then consolidates the list into one, tab-delimited file to be imported into MS Excel.
#
# The script expects a list of servers on the command line to collect the yum check files from.
#
# Example:  "get-yum-update-list.sh <list of servers>"
#

# Check for 1 arguments
if [ $# -lt 1 ]; then
  echo "Usage: $0 <list of servers>"
  echo "Exiting ..."
  echo
  exit 1
fi

# If some servers are not accessible from this server, then set this variable to the
# hostname of the server that has access. For example, to the Dev Enclave servers (that ustc-mgmt
# doesn't have access to).  It's assumed that this server has a copy of this script and a
# "linux.txt" file containing the list of remote servers to collect the data from in your
# home directory.
# Do not list the servers on the command line that this server does not have access to, but
# make sure the file "/home/dsmith/linux.txt" on REMOTE_HOST has the list of servers in it.
REMOTE_HOST=na

# Directory to find and save files
file_dir=/var/tmp

# Copy the files to this server and get the files from the servers accessible from ustc-sftp
# Set the "copy" variable to "1" if you don't want to scp the yum files from the other servers
copy=0
if [ $copy = 0 ]; then
for host in $@
do
  # If REMOTE_HOST is set, then get yum info for the remotely accessible servers
  if [ "x$host" == "x$REMOTE_HOST" ]
  then
    ssh $REMOTE_HOST "/usr/local/sbin/get-yum-update-list.sh `cat linux.txt`" 2>/dev/null
  fi

  # Get the yum info from all the servers
  scp $host:$file_dir/*.yum-check.* $file_dir 2>/dev/null
  chmod g+rw $file_dir/*.yum-check.* 2>/dev/null
  chgrp wheel $file_dir/*.yum-check.* 2>/dev/null
done
fi

# Get the latest Monday's date from the output file of this server
DATE=`ls -1tr $file_dir/*.yum-check* | tail -1 | cut -d. -f3`

# Now consolidate all the yum info into one, space-delimited file

# Get a list of unique packages (including their architecture and version)
declare -a data
cd $file_dir

# The first element in the "data" array is the header line of the output file, which
# includes all the hostnames from the <hostname>.yum-check filenames.
hosts=`ls -1tr *.yum-check.* | awk -F. '{print $1}' | tr "\n" "   " | sed 's/     $/\n/'`
data[0]="Package Task Arch Version Size Priority Notes $hosts"

# Get all unique packages to be updated on any of the boxes and add them to the "data" array
#cat $file_dir/*.yum-check.${DATE} | sed '=' | sed 'N;s/\n/ /g' | tr -s ' ' | sort -u -t" " -k2,5 | sort -n | awk '{print $1,$2,$3","$4","$5,$6}' > $file_dir/all-yum-updates.${DATE}
cat $file_dir/*.yum-check.${DATE} | cut -d" " -f-4 | sort -u | sed "=" | sed 'N;s/\n/ /g' > $file_dir/all-yum-updates.${DATE}
chmod g+rw $file_dir/all-yum-updates.${DATE}
chgrp wheel $file_dir/all-yum-updates.${DATE}

#cat $file_dir/*.yum-check.${DATE} | sed '=' | sed 'N;s/\n/ /g' | tr -s ' ' | sort -u -t" " -k2,5 | sort -n | while read index task pkg_name arch vers hostname
while read index task pkg_name arch vers
do
  # Add the package info to the beginning of the "data" element
  data[$index]="$pkg_name $task $arch $vers tbd tbd tbd"
  # Check for this package in each *yum-check* file and mark the array with an "x" for each server
  for yum_file in `ls -1tr *.yum-check.*`
  do
    grep "${task} $pkg_name $arch $vers" $yum_file > /dev/null
    if [ $? = 0 ]; then
      data[$index]="${data[$index]} y"
    else
      data[$index]="${data[$index]} n"
    fi
  done
done < $file_dir/all-yum-updates.${DATE}

# Add all of the updates (in the "data" array) into a file
i=0
while [ $i -le ${#data[*]} ]
do
  echo ${data[$i]} >> $file_dir/Linux_USTC_Updates_required_`date +%b%Y`.txt
  i=$(( $i + 1 ))
done

exit

#!/bin/bash
set -xv

s h d m dow /path/to/script >/var/log/mylog.log 2>&1