Page History

...

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