Monthly-Report

An Automation Script which does the following tasks

• Downloads incident and change tickets data from Service Now (Ticketing tool)
• Generates
  1. Changes - Completed changes and Upcoming changes for the previous month.
  2. Incidents - Incoming, SLA Hold, In Progress, Resolved, Response Breach and Resolution Breach for previous month
  3. Service Requests for previous month
• Sends a mail to the team placing managers in cc with HTML report and Monthly_Report file attached.

How to configure and install

• Download and extract files from Github.
• Open Terminal and Navigates to Monthly-Report/configure directory.
• Run the following commands.

  chmod 755 setup.py

  ./setup.py

• It download all required dependicies and provides permissions to required files.

Dependencies

• Mutt ( Mail Transfer Protocal)
• Python
• Pip
• Python Libraries used ( pandas, numpy, xlrd, xlsxwriter, os, glob, sys, subprocess, datetime )

How to Run

• Run 1_Download_Service_Now_files_Monthly.sh in terminal.
• Run 2_Send_Monthly_Report.sh in terminal.
• You will be asked whether to mail the report, Press Y/y to send or Press any other key to skip.

Info

• Input folder contains ticket dump downloaded from Service Now.
• Ouput folder contains HTML Mail_Report and Monthly_Report.xlsx files.
• Configure folder contains setup.sh file.
• Script is designed to handle any human errors and service restarts.
• Script will terminate with an termination message and solution, if it encounters any deviations.

Sample Screenshot