Experts,
I was tasked to capture system information(s)and provide the output in excel sheet.
Below details need to be captured.
(Sudoers list,Last login session details,Users/group/Home directory info,Account details with password expiry info,/etc/group and Crontab jobs info list)
Below is the code I started with for capturing the last login details.
<QUOTE>
<CODE>
#!/bin/bash
# Sample script to demonstrate the creation of an HTML report using shell scripting
# Web directory
DIR=/tmp
# A little CSS and table layout to make the report look a little nicer
echo "<HTML>
<HEAD>
<style>
.titulo{font-size: 1em; color: white; background:#0863CE; padding: 0.1em 0.2em;}
table
{
border-collapse:collapse;
}
table, td, th
{
border:1px solid black;
}
</style>
<meta http-equiv='Content-Type' content='text/xls; charset=UTF-8' />
</HEAD>
<BODY>" > $DIR/report.xls
# View hostname and insert it at the top of the xls body
HOST=$(hostname)
echo "Host : <strong>$HOST</strong><br>
Date : <strong>$(date)</strong><br><br>
<table border='1'>
<tr><th class='titulo'>Last Login Session Details</td>
<tr><th class='titulo'>Username</td>
<th class='titulo'>Port</td>
<th class='titulo'>From</td>
<th class='titulo'>Latest</td>
</tr>" >> $DIR/report.xls
# Read the output of df -h line by line
while read line; do
echo "<tr><td align='left'>" >> $DIR/report.xls
echo $line | awk '{print $1}' >> $DIR/report.xls
echo "</td><td align='left'>" >> $DIR/report.xls
echo $line | awk '{print $2}' >> $DIR/report.xls
echo "</td><td align='left'>" >> $DIR/report.xls
echo $line | awk '{print $3}' >> $DIR/report.xls
echo "</td><td align='left'>" >> $DIR/report.xls
echo $line | awk '{print $5" " $6" "$9" "$7}' >> $DIR/report.xls
echo "</td></tr>" >> $DIR/report.xls
done < <(lastlog |grep -vi Username |grep -vi **Never)
echo "</table></BODY></HTML>" >> $DIR/report.xls
</CODE>
</QUOTE>
Error: In the o/p some default users will not be having the details of from session. Can anyone please help me how to change the code for checking the value of it..thanks
