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)

select concat('UPDATE report_service_availability SET outage="',SPLUNK_DATA.outage_time,'", number_of_failures=',SPLUNK_DATA.no_of_failures,', avail=',SPLUNK_DATA.availability,' WHERE base_absid=',opsdb_circuit.circuit_absid,' AND year=',SPLUNK_DATA.year,' AND month=',SPLUNK_DATA.month,';')
FROM SPLUNK_DATA LEFT JOIN SPLUNK_LINK ON (SPLUNK_LINK.ip_address = SPLUNK_DATA.ip_address)
LEFT JOIN opsdb_circuit ON (opsdb_circuit.name = SPLUNK_LINK.circuit_name)
where SPLUNK_DATA.year = 2017
and SPLUNK_DATA.month = 7
and opsdb_circuit.circuit_usage = 'Interconnect'
and opsdb_circuit.status = 'Operational';

...

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.

...