Shell script and reporting to manipulate unix who command(repost)
$30-35 USD
Completed
Posted almost 15 years ago
$30-35 USD
Paid on delivery
Need to create a cron job to be executed every 5 minutes
Use the who command to capture the list of all active user sessions as well as the inactivity period for each session.
FTP a text file snapshot from “who?? every 5 minutes that contains the following:
Date-Time, Username, session id, inactivity period and then have this inserted into DB2 for the graphical analysis (or crystal reports).
Graph 1: Display histogram of number of active user sessions over time
Graph 2: Display histogram of the number of inactive user sessions (over 60 minutes) on the same time axis as above graph. This would indicate if we would realize a gain by setting the timeout parameter for those users.
Graph 3: Display histogram of number of “read only?? users on the same time axis.
## Deliverables
The coder has to be proficient in unix scripting and know the unix commands, especially the WHO command, also udb DB2 on aix and Crystal Reporting; excel is desirable
Please only get involved if have the skills mentioned above
thanks