*** PLEASE NOTE YOU WILL HAVE TO COMPLETE SECTION 3.2 BEFORE COMPLETING THIS SECTION

For Nrens with two connections if either of the connections is up, then the total service is 100%

Please run the following SQL Statement: (Use HeidiSQL - Connect to md_vpn Database)

select CONCAT('UPDATE md_vpn.msr_service_availability SET outage =\'00:00:00\', avail = 1 WHERE service_name=\'',nren_name,'\' AND year = ',year,' AND month = ',month,';')
from md_vpn.msr_vpn_availability
where nren_name in ('DFN','FUnet','GARR','HEAnet','NORDUnet','PIONIER','RENATER','RedIRIS','SUnet')
and ((bgp_lu_access_1 = 100) or (bgp_lu_access_2 = 100))
and year = 2017
and month = 8;

*** Note the year and the month values

Copy the SQL statements produced by the above query and run them

You can view the results at : http://test-msr.geant.net:8888/mdvpn/ms_avail_summ.jsp


  • No labels