# Global Dashboard as Code
This repository holds the code to generate the Dynatrace QM Report.


# Files

## slo_parameter.yaml
This file specifies which SLO should be reported
Example definition:

	TP_Mobile_Login:
		index: 1
		selector_type: "text"
		selector_var: 'CoCo-QM-Report_Mobile'
		yearstart: "2022-01-01"
		displayname: "Login"
		department: "DE-442"
		metric: "func:slo.tp_mobile_login"
		doc_url: "https://atc.bmwgroup.net/confluence/x/R1OqdQ"
		ops_dashboard:
			emea: "https"
			na: ""
			cn: ""
		hubs:
			euprod:
				tiles: ["actual","graph","ytd"]
			naprod:
				tiles: ["actual","graph","ytd"]
			cnprod:
				tiles: ["actual","graph","ytd"]
	thresholds:
		single_value: "99_#577025|98_#f5d30f|0_#ff0000"
		graph_value: "99_#353535|98_#f5d30f|0_#ff0000"

Defintion Description:
Many definitions are for creating the dashboard, the description only reflects the parameters for the QM-Report

	SLO_Name:
			selector_type: str	 		#Query Parameter for Dynatrace
			selector_var: str 			#Query String for Dynatrace
			yearstart: date				#Date in "2022-01-01" format, to specify year-to-date start date
			hubs:						#defines on which hub this SLO is active
				euprod:
					tiles: array		
				naprod:
					tiles: 
				cnprod:
					tiles: 
		
## createReport . py

This script creates the repot as an .xlsx file with the following parameter
  - -h, --help            show this help message and exit
  - -f FROMDATE, --fromDate FROMDATE YYYY-mm-dd e.g. 2022-01-01
  - -t TODATE, --toDate TODATE YYYY-mm-dd e.g. 2022-01-31
  - -p PRESELECT, --preSelect PRESELECT  week | month - gathers the data for the last full week or month 
  - -s SLICES, --slices SLICES  h | d | t | y - writes the slices hourly, daily, total or year to date into ecxel. given in any order

Either -p with a given range (week or month) or the parameters -f AND -t are set

The script reads the slo_parameters.yaml and crawls through all Dynatrace environments to gather the evaluated percentage and creates an excel report with one sheet for each "slice" (e.g. hourly sheet for hourly SLO evaluation, daily sheet for daily SLO evaluation etc.)

## jenkinsfile
The jenkinsfile enables this script to run within a Jenkinspipeline.
It takes the same parameters as the python script and is currently implemented at https://jaws.bmwgroup.net/opapm/job/CoCo%20QM%20Report%202.0/

Triggers
The jenkinsfile as a timely trigger to run automatically every monday at 06:00 a.m

Send Report
Once the report is created, Jenkins sent the report as an attachement to the following recipients:
to: 'rene.forstner@nttdata.com, ermis.wieger@nttdata.com, arnel.arnautovic@nttdata.com, patryk.gudalewicz.bp@nttdata.com, stephan.oertelt@bmw.de, Mohammed.Abadel@bmw.de, michaela.jaeger@bmw.de, OOC-Support@bmwgroup.com, Sonja.Yildizoglu@bmw.de, Andreas.DA.Danzer@partner.bmw.de',