3.1 MD-VPN Availability Summary

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

Please run the following SQL Statement:

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