Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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;

...