Page History

** Please refer to section Note: Section 3.1 Availability in explains how to obtain the raw data. Info ONLY.

Run the following SQL command in the reports database on test-msr.geant.net: (Use Heidi-SQL)

...

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

Note: Make sure WIX, UK-MANLAN and FR-MANLAN do not exist in the MSR page, run the query and delete the entries:

Query:  select * from report_service_availability where year = 2019 and month =11 and base_absid in('41226', '41375', '43223');

Update MTTR and MTBF

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.

...