Page History

Some of the circuits within OpsDB need to be ignored by the MSR, such as the Cloud Services circuits. As such, run the following queries on test-msr.geant.net reports database:

Use MySQL Workbench to connect to reports database with user reportsUser on test-msr VM. Or connect via the Putty session (while on test-MSR) using this line "mysql -u reportsUser -p reports", look in KeePass for password. This will prompt to enter the password which is stored in LastPass

Run the 2 queries below:

1- UPDATE opsdb_circuit oc inner join circuit c ON c.absid = oc.circuit_absid

...