...

Check your results by using the link: http://test-msr.geant.net:8888/msr/ms_ip_avail_new.jsp

** WARNING - Sometimes it might be necessary to manually update the data. Run the following two SQL statements to correct any of the data.

UPDATE reports.report_service_availability SET
outage = '13:15:53',
number_of_failures = 27
WHERE year = 2017
AND month = 7
AND base_absid = 31467;

** Pay attention to the circuit absid, year and month values in the SQL statement

** The base_absid is the absid of the circuit we want to change.  You can verify the circuit information by checking the OpsDB Application using the following link: http://opsdb.dante.net/circuit-display-basic.phtml?absid = 3674;=31467  alternatively you could use the following query:

SELECT * FROM reports.opsdb_circuit

WHERE cirtcuit_absid = 31467;

After you have run the previous update SQL statement, then you will need to run the following SQL statement to calculate the availability, MTTR, MTBF of the service.

** WARNING in order to obtain accurate availability, availability during maintenance, mean-time-to-repair (MTTR), mean-time-between-failures (MTBF), we need to use the correct number of seconds for the particular month.

28 Days = 2419200 seconds

29 Days = 2505600 seconds

30 Days = 2592000 seconds

31 Days = 2678400 seconds

UPDATE reports.report_service_availability SET

MTTR = TIME_FORMAT(SEC_TO_TIME(time_to_sec(outage)/number_of_failures),'%H:%i:%s'),
MTBF = TIME_FORMAT(SEC_TO_TIME((2678400 - time_to_sec(outage))/number_of_failures),'%H:%i:%s'),
avail = (2678400 - time_to_sec(outage))/2678400 ,
avail_maint = (2678400 - time_to_sec(out_maint))/2678400 
WHERE year = 2017
AND month = 7
AND number_of_failures > 0;

** Pay attention to the year and month and seconds values in the SQL statement

Overall View

You will notice that some NRENS have one connection to GEANT such as: 

...