项目作者: abdu1azeez

项目描述 :
Automation Script which sends weekly report to team via mail.
高级语言: Python
项目地址: git://github.com/abdu1azeez/Weekly-Report.git
创建时间: 2019-04-24T14:39:49Z
项目社区:https://github.com/abdu1azeez/Weekly-Report

开源协议:

下载


Weekly-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 week.
    2. Incidents - Incoming, SLA Hold, In Progress, Resolved, Response Breach and Resolution Breach for previous week
    3. Service Requests for previous week
  • Sends a mail to the team placing managers in cc with HTML report and Weekly_Report file attached.

    #

How to configure and install

  • Download and extract files from Github.
  • Open Terminal and Navigates to Weekly-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_Weekly.sh in terminal.
  • Run 2_Send_Weekly_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 Weekly_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

Mail_Report

#