An Automation Script which does the following tasks
- Downloads incident and change tickets data from Service Now (Ticketing tool)
- Generates
- Changes - Completed changes and Upcoming changes for the previous week.
- Incidents - Incoming, SLA Hold, In Progress, Resolved, Response Breach and Resolution Breach for previous week
- Service Requests for previous week
- Sends a mail to the team placing managers in cc with HTML report and Weekly_Report file attached.
- 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.
- Mutt ( Mail Transfer Protocal)
- Python
- Pip
- Python Libraries used ( pandas, numpy, xlrd, xlsxwriter, os, glob, sys, subprocess, datetime )
- 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.
- 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.