Page History

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;

This needs to be updated.

Log into prod-cacti01-fra-de.geant.net as yourself (using dante.surname credentials)

Run the following command (it should take about 45 minutes to 1 hour to complete):

cd /home/cactiuser/scripts

sudo ./otrsmaintenance.sh -y2017 -m8

** Pay attention to the year and the month value in the above statement. 

A log file is produced in /home/cactiuser/scripts called OTRS_Maintenance-yyymmdd.log** Pay attention to the circuit absid, year and month values in the SQL statement