Page History

...

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

...