The scripts are on test-msr.geant.net (62.40.104.162 83.97.92.151) and in the /opt/msr-reports/reports directory.

The main script is called report_generate.sh which in turn calls other MySQL Stored procedures and other Bash Shell Scripts.

The definitions for the MySQL Stored Procedures can be reviewed in the reporting-ddl.sql and reporting-dml.sql files.

The scripts use a configuration file called config.inc to define MySQL connection information.

A tree structure for the main script, report_generate.sh is as follows:

report_generate.sh

dashboard_import.sh

opsdb_import_new.sh

msr_migration.php

find_parent.sh

report_calculate_utilisation.sh

report_calculate_availability_part1.sh

Switch to root (sudo su)

Run the report_generate.sh with relevant year and month

Example of running the report generator script for July 2017:

cd to /opt/msr-reports/reports

nohup ./report_generate.sh -y 2017 -m 7 >jul_msr.txt &    (DO NOT TYPE CTRL+C ...THIS WILL CANCEL THE SCRIPT. INSTEAD YOU CAN JUST CLOSE THE TERMINAL)

The script takes approximately anywhere between 10 and 45 minutes to run, when complete the last line of the output file will read:

*** report_generate.sh Complete *** Date / time

*** run: "tail -f ./jul_msr.txt"  — This will give a live update of the bottom content of the file. Once the process is completed you will see a message like the below one:

*** report_generate.sh Complete *** Tue Jan 23 12:16:59 UTC 2018

2nd Script:

Once the above script has completed, then run the following script:

Switch to root (sudo su)

cd to /opt/msr-reports/reports

nohup ./report_calculate_availability_part2.sh -y 2017 -m 7 >jul_msr_part2.txt &        (DO NOT TYPE CTRL+C ...THIS WILL CANCEL THE SCRIPT. INSTEAD YOU CAN JUST CLOSE THE TERMINAL)

** The above script can take at least 4 hours to run

** nohup means you can close the SSH window, without killing the process/session