#!/bin/ksh
#
# $Log: get_sysinfo_convert_html,v $
# Revision 1.6  2008/10/17 13:42:28  mbaker
# added Date field
#
# Revision 1.5  2008/09/24 18:22:40  mbaker
# added CD-ROM DVD
#
# Revision 1.4  2008/09/23 01:59:35  mbaker
# changed prints to ECHO
#
# Revision 1.3  2008/08/29 15:21:41  mbaker
# added company argument for HTML header
#
# Revision 1.2  2008/08/16 17:55:28  mbaker
# added RAIDL
#
# Revision 1.1  2008/06/26 02:08:55  mbaker
# Initial revision
#
#
###############################################################################
#DOCBEGIN
#
# Script to convert colon delimited get_sysinfo file into a html table.
#
# The script combines individual config file into one, by doing
#   cat $SRCDIR/*.sysinfo.db > $SRCFILE
#
#   It expects the input files from all systems to be in the format of:
#   $HOSTNAME.sysinfo.db (which is the default output of get_sysinfo).
#
#
#  Matt Baker - mbaker@computeranddata.com
#  Latest copy available at www.computeranddata.com/scripts
#  Version 4.3  08/29/2008
#
#DOCEND
###############################################################################

TMPDIR=/tmp
TMPFILE=$TMPDIR/html-format.$$

COMPANY=""

DESTDIR=/www
DESTFILE=$DESTDIR/company-sysinfo.html

SRCDIR=/nfsserver/data/get_sysinfo
SRCFILE=$SRCDIR/sysinfo.db

HEADERLINES=10
RULERLINES=5
HEADERONLY=0
VERBOSE=0
DEBUG=0
STDOUT=0
DATE="$(date)"

HEADER="
 <th>Item</th>
 <th>Hostname</th>
 <th>Hostid</th>
 <th>Serial Number</th>
 <th>OS Type</th>
 <th>OS Version</th>
 <th>Hardware Release</th>
 <th>Kernel Patch</th>
 <th>Arch</th>
 <th>Platform</th>
 <th>Model</th>
 <th>Kernel 32/64 Bit</th>
 <th>System Firmware</th>
 <th>CPU Qty</th>
 <th>CPU Speed</th>
 <th>Memory Size</th>
 <th>Page Size</th>
 <th>Swap Size</th>
 <th>DNS Domainname</th>
 <th>Virtual:Zones,VIO</th>
 <th>VNAMEs:VIPs</th>
 <th>Sun DOMAINs,LPARs,NPARs</th>
 <th>Diskgroups</th>
 <th>ZFS Pools</th>
 <th>Total Disk</th>
 <th>SMALL</th>
 <th>2GB</th>
 <th>4GB</th>
 <th>8GB</th>
 <th>18GB</th>
 <th>36GB</th>
 <th>73GB</th>
 <th>100GB</th>
 <th>150GB</th>
 <th>200GB</th>
 <th>300GB</th>
 <th>500GB</th>
 <th>gte 1TB</th>
 <th>EMC SAN</th>
 <th>EMC BCVs</th>
 <th>IBM SAN</th>
 <th>HDS SAN</th>
 <th>CD-ROM/DVD</th>
 <th>HBA</th>
 <th>HBA Type</th>
 <th>HBA Driver</th>
 <th>HBA Firmware</th>
 <th>HBA Fcode</th>
 <th>NET</th>
 <th>NIC:100Mb</th>
 <th>NIC:Gb</th>
 <th>Boards</th>
 <th>GBIC</th>
 <th>SOC</th>
 <th>SCSI</th>
 <th>FDDI</th>
 <th>HSI</th>
 <th>VIDEO</th>
 <th>SSA</th>
 <th>A5000</th>
 <th>A5000 ARRAY NAMES</th>
 <th>Netra D130</th>
 <th>RAIDL</th>
 <th>Java</th>
 <th>Perl</th>
 <th>VXVM</th>
 <th>VXFS</th>
 <th>VCS</th>
 <th>Netbackup</th>
 <th>TSM</th>
 <th>PowerPath</th>
 <th>ECC</th>
 <th>ESN Manager</th>
 <th>Volume Logix</th>
 <th>Fibre Zone</th>
 <th>Patrol</th>
 <th>Scheduler</th>
 <th>Forte</th>
 <th>Apache</th>
 <th>Netscape</th>
 <th>Websphere</th>
 <th>Weblogic</th>
 <th>Broadvision</th>
 <th>SQL Backtrack</th>
 <th>TripWire</th>
 <th>SSH</th>
 <th>Usage</th>
 <th>Location</th>
 <th>Busines Unit</th>
 <th>Server Purpose</th>
 <th>Lease Number</th>
 <th>Previous Hostnames</th>
 <th>Page if down</th>
 <th>Maintenance Level</th>
 <th>Data Capture Date</th>
"

OSTYPE=$(uname 2> /dev/null)

if [[ $OSTYPE = SunOS ]]
then
	if [[ -f /usr/ucb/echo ]]
	then
		ECHO="/usr/ucb/echo"
	else
		#use ksh print
		ECHO="print"
		#ECHO="/usr/bin/echo"
	fi

elif [[ $OSTYPE = AIX ]]
then
	#use ksh print
	ECHO="print"
	#ECHO="/usr/bin/echo"

elif [[ $OSTYPE = HP-UX ]]
then
	#use ksh print
	ECHO="print"
	#ECHO="/usr/bin/echo"

elif [[ $OSTYPE = Linux ]]
then
	ECHO="/bin/echo"

elif [[ -n $(echo $OSTYPE | grep ^CYGWIN) ]]
then
	ECHO="/usr/bin/echo"
fi


###########
# PARSING: read in options & arguments 
###########

while (( $# ))
do
	case $1 in

		-sd) shift

			if (( $# ))
			then
				SRCDIR=$1
				#
				# set file here so it knows new path, can be overriden later
				#
				SRCFILE=$SRCDIR/sysinfo.db
				shift
				if [[ ! -d $SRCDIR ]]
				then
					$ECHO "ERROR:4: srcdir $SRCDIR doesn't exist"
					exit 4
				fi
			else
				$ECHO "ERROR:1: srcdir (-sd) needs an argument" 
				exit 1
			fi
			;;

		-sf) shift

			if (( $# ))
			then
				SRCFILE=$SRCDIR/$1
				shift
				touch $SRCFILE 2> /dev/null
				if [[ ! -f $SRCFILE ]]
				then
					$ECHO "ERROR:5: srcfile $SRCFILE cannot create"
					exit 5
				fi
			else
				$ECHO "ERROR:1: srcfile (-sf) needs an argument"
				exit 1
			fi
			;;

		-dd) shift

			if (( $# ))
			then
				DESTDIR=$1
				#
				# set file here so it knows new path, can be overriden later
				#
				DESTFILE=$DESTDIR/company-sysinfo.html
				shift
				if [[ ! -d $DESTDIR ]]
				then
					$ECHO "ERROR:4: destdir $DESTDIR doesn't exist"
					exit 4
				fi
			else
				$ECHO "ERROR:1: destdir (-dd) needs an argument"
				exit 1
			fi
			;;


		-df) shift

			if (( $# ))
			then
				DESTFILE=$DESTDIR/$1
				shift
				touch $DESTFILE 2> /dev/null
				if [[ ! -f $DESTFILE ]]
				then
					$ECHO "ERROR:5: destfile $DESTFILE cannot create"
					exit 5
				fi
			else
				$ECHO "ERROR:1: destfile (-df) needs an argument"
				exit 1
			fi
			;;

		-c) shift
			COMPANY="$1"
			shift
			;;

		-stdout) STDOUT=1
			shift
			;;

		-header*) HEADERONLY=1
			shift
			;;

		-debug) DEBUG=1
			shift
			;;

		-v) VERBOSE=1
			shift
			;;

		-info | -doc) 
			awk '/DOCBEGIN/, /DOCEND/' $0 \
						| sed -e 's/^#//' \
						| sed -e '/DOCBEGIN/d' \
						| sed -e '/DOCEND/d' \
						|  more
			exit 0
			;;

		-h|*) if [[ $1 != -h ]]
			then
				$ECHO "\n   OPTION: $1 is invalid.\n"
			else
				$ECHO ""
			fi

##############################################################################
cat << EOF
Usage: $0:
Usage: $0: [-debug] [-v] [-headeronly] [-stdout]
Usage: $0: [-c companyname] [-sd SRCDIR ] [-sf SRCFILENAME ] [-dd DESTDIR ] [-df DESTFILENAME ] 
Usage: $0: -info | -doc
Usage: $0: -h

 no args: defaults to combined files in HTML output
 -headeronly: print out HEADER ONLY
 -stdout: print output to stdout (still saves to DESTFILE)
  -debug: debug mode, does a 'set -x' 
      -o: lists running oracle instances/SIDs (based upon a unique standard)
      -v: verbose mode

-info|doc: print out header of program (document)
      -h: help - command synopsis (this listing)
EOF
##############################################################################
			exit 1
			;;
	esac
done


if (( DEBUG ))
then
	set -x
fi

if [[ -n $COMPANY ]]
then
	COMPANY=" for $COMPANY"
fi

#
# Turn HEADER into colon delimited output, output it, then exit
#
if (( HEADERONLY ))
then
	$ECHO $HEADER \
			| sed -e 's/<th>//' \
			| sed -e 's/<\/th>$//' \
			| sed -e 's/> </>:</g' \
			| sed -e 's/<th>//g' \
			| sed -e 's/<\/th>//g' 
	exit 0
fi

if (( VERBOSE ))
then
	$ECHO "starting conversion"
fi

#
# grab each individual config file and combine into one
#
cat $SRCDIR/*.sysinfo.db > $SRCFILE

#
# do header
#
cat << EOF > $TMPFILE
<HTML>
<BODY>
<FONT SIZE=5>

<TABLE border=10>
<H2>Server Configs $COMPANY</H2>
Last Modified on: $DATE <P>

<tr>
$HEADER
</tr>
EOF

#
# add html to each line for table formatting
#
CNT=1

if (( VERBOSE ))
then
	$ECHO -n "Doing server/line number..."
fi

while read -r line
do
	if (( VERBOSE ))
	then
		$ECHO -n "${CNT}..."
	fi

	# translate colons to tables
	line=$($ECHO "$line" | sed 's@:@</td><td nowrap>@g')

	# add table format for beginning and end of each line
	line=$($ECHO "<td>${CNT}</td><td>${line}</td>")


	$ECHO "<tr>"  >> $TMPFILE
	$ECHO "$line" >> $TMPFILE
	$ECHO "</tr>" >> $TMPFILE

	#
	# repeat the "rule" (double lines) every X lines
	#
	if (( $CNT % $RULERLINES == 0 ))
	then
		$ECHO "<tr><td HEIGHT="10"> </td></tr>" >> $TMPFILE
		#$ECHO "<tr> </tr>" >> $TMPFILE
		#$ECHO "<tr> </tr>" >> $TMPFILE
	fi
	
	#
	# repeat the header every X lines
	#
	if (( $CNT % $HEADERLINES == 0 ))
	then
	cat <<- EOF >> $TMPFILE
    <tr>
	$HEADER
    </tr>
		EOF
	fi
	
	let CNT=$CNT+1

done < $SRCFILE


#
# do footer
#
cat << EOF >> $TMPFILE
</TABLE>
EOF

cat << EOF >> $TMPFILE
</BODY>
</HTML>
EOF

if [[ ! -d $DESTDIR ]]
then
	$ECHO "ERROR:4: destdir $DESTDIR doesn't exist"
	exit 4
fi

mv $TMPFILE $DESTFILE

#
# print to STDOUT (if set), then output save filename regarless
#
if (( STDOUT ))
then
	cat $DESTFILE
else
	if (( VERBOSE ))
	then
		$ECHO "completed conversion"
		$ECHO "See outputfile $DESTFILE"
	fi
fi