3.3 Planned Maintenance

On pages that contain circuit availability data such as the IP Access Detailed View: http://test-msr.geant.net:8888/msr/ms_ip_avail_new.jsp There is a column for the Total Outage Time During Maintenances.

UPDATE reports.report_service_availability
SET out_maint = '06:00:00'
WHERE base_absid = 31467
AND year = 2017
AND month = 7;

** The base_absid is the absid of the circuit we want to change.  You can verify the circuit information by checking the OpsDB Application using the following link: http://opsdb.dante.net/circuit-display-basic.phtml?absid=31467  alternatively you could use the following query:

SELECT * FROM reports.opsdb_circuit
WHERE cirtcuit_absid = 31467;

** Pay attention to the circuit absid, year and month values in the SQL statement