[[Category:rchanOPS435-Python]][[Category:OPS435-Pythonrchan]]The =Assignment 2 will be - Usage Report='''Weight:''' 15% of the dbda script. Instead of giving multiple choices, we will focus on a specific assignment that is most reasonable. The previous assignment options will be moved to a practice area, where they will be useful for studying and exploring deeper into python.overall grade

= Assignment 2 =Test your Python code '''Late Penalty:''' 20% per school day, and upload your tested python program note that this assignment must be completed satisfactorily in order to Blackboard by the due date(Friday Aug 3)* [[OPS435 Python Assignment 2 A| dbda]] - a python program to report the (n) day before or pass the (n) day after a given date in the "YYYYMMDD" format. Extra options are added to give more outputcourse even if you get zero mark for this assignment.

==Overview== Due DateMost 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: Friday Aug 3 ====<pre>$ last -Favhuo 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) ...</pre>

= Practice and Bonus =* [[OPS435 Python Assignment 2 B| weekly usage report chart]] - get the weekly usage data from In this assignment 1 for a selected user and use the openpyxl module , your task is to create a Excel spread sheet with bar chart.* [[OPS435 Python Assignment 2 C| report partition information]] on a block device (both physical python program to produce daily, weekly, and virtual) monthly usage reports by reading user or by remote host based on the partition information directly obtained from the device'last' command or given files which contain similar information as the 'last' command.

More == Resource for useful modules ==* the <b>argparse</b> module** [https://docs.python.org/3/howto/argparse.html Argparse Tutorial] - should read this first.** [https://docs.python.org/3/library/argparse.html Argparse API reference information page]* the <b>time</b> module** [https://www.tutorialspoint.com/python3/python_date_time.htm Time module Tutorial]** [https://docs.python.org/3/library/time.html Time module API reference page] == Instructions == === Program Name and valid command line arguments ===Name your Python3 program as <code>ur.py</code>. The program should accept one or more "file name" as its command line parameters and other optional parameters as shown below. Your ur.py script should produce the following usage when run with the --help option:<pre>[rchan@centos7 a1]$ python3 ./ur.py -husage: ur.py [-h] [-l {user,host}] [-r RHOST] [-t {daily,weekly,monthly}] [-u USER] [-v] F [F ...] Usage Report based on the last command positional arguments: F list of files to comebe processed optional arguments: -h, --help show this help message and exit -l {user,host}, --list {user,host} generate user name or remote host IP from the given files -r RHOST, --rhost RHOST usage report for the given remote host IP -t {daily,weekly,monthly}, --type {daily,weekly,monthly} type of report: daily, weekly, and monthly -u USER, --user USER usage report for the given user name -v, --verbose tune on output verbosity Copyright 2018 - Raymond Chan </pre>Replace the last line with your own full name   If one of the file name given is "last", 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 <font color='red'><b><u>single source file</u></b></font>. Please include the following declaration by <b><u>you</u></b> as the script level docstring in your Python source code file (replace [Student_id] with your Seneca email user name, and "Student Name" with your own name): <source>OPS435 Assignment 2 - Fall 2018Program: ur_[Stduent_id].pyAuthor: "Student Name"The python code in this file ur_[Student_id].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 except those providedby the course instructor. I have not shared this python file with anyoneor 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.</source>  ==== Daily Usage Report by User ====The following is a sample Daily Usage Report for user1 on host.cty.senecacollege.ca:<pre>Daily Usage Report for user1============================Date Usage in seconds2018 02 14 602018 02 07 452018 02 01 5 Total 110</pre> ==== Daily Usage Report by Remote Host====The following is a sample Daily Usage Report from Remote Host 10.94.10.25 on host.cty.senecacollege.ca: <pre>Daily Usage Report from 10.94.10.25 ===================================Date Usage in seconds2018 02 14 302018 02 07 412018 02 01 9 Total 80</pre> ==== Weekly Usage Report by User ====The following is a sample Weekly Usage Report for user1 on host.cty.senecacollege.ca: <pre>Weekly Usage Report for user1=============================Week # Usage in Seconds2017 01 1602017 02 452017 03 52017 04 20 Total 220</pre> ==== Weekly Usage Report by Remote Host ====The following is a sample Weekly Usage Report from the remote host 10.94.10.25 on host.cty.senecacollege.ca: <pre>Weekly Usage Report from 10.94.10.25====================================Week # Usage in Seconds2017 01 302017 03 412017 05 92017 06 11 Total 91</pre> ==== Monthly Usage Report by User ====The following is a sample Monthly Usage Report for user1 on host.cty.senecacollege.ca:<pre>Monthly Usage Report for user1==============================Month Usage in Seconds2017 01 1602017 02 45 Total 205</pre> ==== Monthly Usage Report by Remote Host ====The following is a sample Monthly Usage Report for 10.94.10.25 on host.cty.senecacollege.ca: <pre>Monthly Usage Report from 10.94.10.25=====================================Month Usage in Seconds2017 01 302017 02 41 Total 71</pre> == Program Development and Testing ==You should create python functions to handle the following sub-tasks:* 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 hostTo help you with this assignment, [[OPS435 A1 Usage Report Template|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 and sample run ==* [https://scs.senecac.on.ca/~raymond.chan/ops435/a1/ Sample test date files and sample runs] == Rubric == {| class="wikitable" border="1"! Task !! Maximum mark !! Actual mark|-| Program Authorship Declaration ||1 |||-| Program usage || 2 |||-| Program Options || 2 |||-| Daily Usage Report by User || 2 |||-| Daily Usage Report by Remote Host || 2 |||-| Weekly Usage Report by User || 2 |||-| Weekly Usage Report by Remote Host || 2 |||-| Monthly Usage Report by User || 2 |||-| Monthly Usage Report by Remote Host || 2 |||-| Get Login Records from 'last' || 2 |||-| Get Login Records from files || 2 |||-| Generate user name list || 2 |||-| Generate remote host IP list|| 2 || |-| '''Total''' || 25 ||  |} == Submission ==After fully testing your program, submit your python file on Blackboard