OPS435 Assignment 1 A
Assignment 1 - Usage Report
Weight: 15% of the overall grade
Due Date: Ask your professor for exact date
Late Penalty: 10% per school day, and note that this assignment must be completed satisfactorily in order to pass the course even if you get zero mark for this assignment.
Overview
Most system administrators would like to know the utilization of their systems by their users. On a Linux system, each user's login records are normally stored in the binary file /var/log/wtmp. The login record in this binary file can not be viewed or edited directly using normal Linux text commands like 'less', 'cat', etc. The 'last' command is often used to display the login records stored in this file in a human readable form. Please check the man page of the 'last' command for available options. The following listing is a sample output of the 'last' command with the '-F' flag on:
$ last -F avhuo pts/9 10.43.222.35 Tue Feb 13 16:53:42 2018 - Tue Feb 13 16:57:02 2018 (00:03) clee18 pts/6 10.40.43.94 Tue Feb 13 16:51:47 2018 - Tue Feb 13 16:56:13 2018 (00:04) clee18 pts/6 10.40.43.94 Tue Feb 13 16:50:20 2018 - Tue Feb 13 16:51:27 2018 (00:01) shana pts/2 toroon4512w-lp13 Tue Feb 13 16:47:48 2018 - Tue Feb 13 16:58:31 2018 (00:10) hfang171 pts/4 24.114.50.50 Tue Feb 13 16:31:38 2018 - Tue Feb 13 17:48:39 2018 (01:17) bigia pts/8 10.247.6.126 Tue Feb 13 16:28:43 2018 - Tue Feb 13 17:28:31 2018 (00:59) ckim16 pts/2 10.40.91.236 Tue Feb 13 16:22:36 2018 - Tue Feb 13 16:45:10 2018 (00:22) ddchan pts/2 10.43.115.162 Tue Feb 13 16:19:29 2018 - Tue Feb 13 16:22:00 2018 (00:02) tsliu2 pts/4 10.40.105.130 Tue Feb 13 16:17:21 2018 - Tue Feb 13 16:30:10 2018 (00:12) shana pts/13 10.40.91.247 Tue Feb 13 16:07:52 2018 - Tue Feb 13 16:45:52 2018 (00:38) tchiu2 pts/11 10.40.105.130 Tue Feb 13 16:07:43 2018 - Tue Feb 13 16:17:12 2018 (00:09) ...
In this assignment, your task is to create a python program to produce daily, weekly, and monthly usage reports by user or by remote host based on the information obtained from the 'last' command or given files which contain similar information as the 'last' command.
Instructions
Program Name and valid command line arguments
Name your Python3 program as usage_report.py. The program should accept zero or more "file name" as its command line parameters. for examples:
-
python3 usage_report.py, or -
python3 usage_report.py filename, or -
python3 usage_report.py filename1 filename2etc ... - any number of file names from 1 to as many as the command-line supports.
If there is no command line argument, your python program should get the login records from the 'last' command with the appropriate flags.
If there is one file name provided at the command line, read the login records from the contents of the given file. The format of each line in the file should be the same as the output of 'last -Fiw'.
If there is more than one file name provided, merges all the files together with the first one at the top and the last one at the bottom. Read and process the file contents in that order in your program.
Header
All your Python codes for this program must be placed in a single source file. Please include the following declaration by you as comment in your Python source code file (replace "Student Name" with your own name):
OPS435 Assignment 1 - Winter 2018
Program: usage_report.py
Author: "Student Name"
The python code in this file (usage_report.py) is original work written by
"Student Name". No code in this file is copied from any other source
including any person, textbook, or on-line resource. I have not shared
this python program with anyone or anything except for submission for grading.
I understand that the Academic Honesty Policy will be enforced and violators
will be reported and appropriate action will be taken.Main Menu
When your Python program is running, it should present the user with the following menu:
Reading login records... Done.
Usage Report - Main Menu
========================
d) Daily Usage Report
w) Weekly Usage Report
m) Monthly Usage Report
q) QuitDisplay an appropriate sub-menu when option d, w, or m is selected.
When option q is selected, you program should terminate.
Redisplay the same menu if the user entered any other letters.
Daily Usage Menu
- If the Daily Usage Report option is selected from the Main Menu, the following sub-menu should be presented on the screen:
Daily Usage Report Menu
=======================
u) By User
h) By Remote Host
r) Return to Main MenuWhen option u is selected, the sub-menu for Daily Usage Report by User should be displayed.
When option h is selected, the sub-menu for Daily Usage Report by Remote Host should be displayed.
When option r is selected, the main menu should be displayed.
Redisplay the same menu if the user entered any other letters.
Daily Usage Report by User
Daily Usage Report - by User
============================
0) All users
1) user1
2) user2
3) user3
...
9) user9
r) Return to Daily Usage Report MenuNote: If there are fewer than 9 users, display only the actual number of users on the menu.
When option r is selected, the previous Daily Usage Report menu should be displayed.
When one of 0-9 is selected, the Daily Usage Report for the selected user(s) should be generated.
Redisplay the same menu if the user entered any other digits/letters.
The following is a sample Daily Usage Report for user1 on host.cty.senecacollege.ca:
Daily Usage Report for user1 on host.cty.senecacollege.ca ========================================================= Date Usage in Minutes 2018-02-14 60 2018-02-07 45 2018-02-01 5 Total 110
Daily Usage Report by Remote Host
Daily Usage Report - by Remote Host
===================================
0) All Remote Host
1) 10.94.10.25
2) 10.94.10.120
3) 172.16.99.1
...
9) 192.168.45.3
r) Return to Daily Usage Report MenuNote: If there are fewer than 9 remote hosts, display only the actual number of remote host on the menu.
When option r is selected, the previous Daily Usage Report menu should be displayed.
When one of 0-9 is selected, the Daily Usage Report for the selected Remote Host(s) should be generated.
Redisplay the same menu if the user entered any other digits/letters.
The following is a sample Daily Usage Report from Remote Host 10.94.10.25 on host.cty.senecacollege.ca:
Daily Usage Report from 10.94.10.25 on host.cty.senecacollege.ca ================================================================ Date Usage in Minutes 2018-02-14 30 2018-02-07 41 2018-02-01 9 Total 80
Weekly Usage Menu
- If the Weekly Usage Report option is selected from the Main Menu, the following sub-menu should be presented on the screen:
Weekly Usage Report Menu
========================
u) By User
h) By Remote Host
r) Return to Main MenuWhen option u is selected, the sub-menu for Weekly Usage Report by User should be displayed.
When option h is selected, the sub-menu for Weekly Usage Report by Remote Host should be displayed.
When option r is selected, the main menu should be displayed.
Weekly Usage Report by User
Weekly Usage Report - by User
=============================
0) All Users
1) User1
2) User2
3) User3
...
9) User9
r) Return to Weekly Usage Report MenuNote: If there are fewer than 9 users, display only the actual number of user on the menu.
When option r is selected, the previous Weekly Usage Report menu should be displayed.
When one of 0-9 is selected, the Weekly Usage Report for the selected user(s) should be generated from week 1 to week 52, skips the week where the weekly usage is zero.
Redisplay the same menu if the user entered any other digits/letters.
The following is a sample Weekly Usage Report for user1 on host.cty.senecacollege.ca:
Weekly Usage Report for user1 on host.cty.senecacollege.ca ========================================================= Week # Usage in Minutes 1 160 2 45 3 5 4 20 Total 220
Weekly Usage Report by Remote Host
Weekly Usage Report - by Remote Host
===================================
0) All Remote Hosts
1) 10.94.10.25
2) 10.94.10.120
3) 172.16.99.1
...
9) 192.168.45.3
r) Return to Weekly Usage Report MenuNote: If there are fewer than 9 remote hosts, display only the actual number of remote host on the menu.
When option r is selected, the previous Weekly Usage Report menu should be displayed.
When one of 0-9 is selected, the Weekly Usage Report for the selected Remote Host(s) should be generated from week 1 to week 52, skip the week where the weekly usage is zero.
Redisplay the same menu if the user entered any other digits/letters.
The following is a sample Weekly Usage Report from the remote host 10.94.10.25 on host.cty.senecacollege.ca:
Daily Usage Report from 10.94.10.25 on host.cty.senecacollege.ca ================================================================ Week # Usage in Minutes 1 30 3 41 5 9 6 11 Total 91
Monthly Usage Menu
- If the Monthly Usage Report option is selected from the Main Menu, the following sub-menu should be presented on the screen:
Monthly Usage Report Menu
=========================
u) By User
h) By Remote Host
r) Return to Main MenuWhen option u is selected, the sub-menu for Monthly Usage Report by User should be displayed.
When option h is selected, the sub-menu for Monthly Usage Report by Remote Host should be displayed.
When option r is selected, the main menu should be displayed.
Monthly Usage Report by User
Monthly Usage Report - by User
==============================
0) All Users
1) User1
2) User2
3) User3
...
9) User 9
r) Return to Monthly Usage Report MenuNote: If there are fewer than 9 users, display only the actual number of user on the menu.
When option r is selected, the previous Monthly Usage Report menu should be displayed.
When one of 0-9 is selected, the Monthly Usage Report for the selected user(s) should be generated for Jan to Dec. Skips the month where the Monthly Usage is zero.
Redisplay the same menu if the user entered any other digits/letters.
The following is a sample Monthly Usage Report for user1 on host.cty.senecacollege.ca:
Monthly Usage Report for user1 on host.cty.senecacollege.ca =========================================================== Month Usage in Minutes January 160 February 45 Total 205
Monthly Usage Report by Remote Host
Monthly Usage Report - by Remote Host
=====================================
0) All Remote Hosts
1) 10.94.10.25
2) 10.94.10.120
3) 172.16.99.1
...
9) 192.168.45.3
r) Return to Monthly Usage Report MenuNote: If there are fewer than 9 remote hosts, display only the actual number of remote host on the menu.
When option r is selected, the previous Monthly Usage Report menu should be displayed.
When one of 0-9 is selected, the Monthly Usage Report for the selected Remote Host(s) should be generated for Jan to Dec. Skips that month where the Monthly Usage is zero.
Redisplay the same menu if the user entered any other digits/letters.
The following is a sample Monthly Usage Report for 10.94.10.25 on host.cty.senecacollege.ca:
Monthly Usage Report from 10.94.10.25 on host.cty.senecacollege.ca ================================================================ Week # Usage in Minutes January 30 February 41 Total 71
Program Development and Testing
You should create python functions to handle the following sub-tasks:
- displays main menu, sub-menu and get user's response via the keyboard
- gets login records from the output of "last" command and filters out unwanted records
- reads login records from files and filters out unwanted records
- generate daily usage reports by user or by remote host
- generate weekly usage reports by user or by remote host
- generate monthly usage reports by user or by remote host
To help you with this assignment, here is a template you can use as a starting point in developing your Python Usage Report program.
Once you have finished coding a function, you should start a Python3 interactive shell, import your functions and manually call the function you want to test.
Once you have all the individual function tested and that each is working properly, perform the final test with test data provided by your professor and verify that your program produces the correct results before submitting your python program on Blackboard.
Sample login records file
- Will be provide on Feb 22, 2018
Rubric
| Task | Maximum mark | Actual mark |
|---|---|---|
| Program Authorship Declaration | 1 | |
| Main Menu | 2 | |
| Daily Usage Menu | 1 | |
| Daily Usage Report by User Menu | 1 | |
| Daily Usage Report by Remote Host Menu | 1 | |
| Weekly Usage Menu | 1 | |
| Weekly Usage Report by User Menu | 1 | |
| Weekly Usage Report by Remote Host Menu | 1 | |
| Monthly Usage Menu | 1 | |
| Monthly Usage Report by User Menu | 1 | |
| Monthly Usage Report by Remote Host Menu | 1 | |
| Get Login Records from 'last' | 3 | |
| Get Login Records from files | 3 | |
| Generate Daily Usage Report | 2 | |
| Generate Weekly Usage Report | 2 | |
| Generate Monthly Usage Report | 2 | |
| Total | 24 |
Submission
After fully testing your program, submit the .py file on Blackboard