Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

-- update opsdb_circuit set family = 'Managed Wavelength' where circuit_absid in (11377,23111);

-- The above 2 services are not managed wavelengths, should this be here now?

-- Neither 'managed wavelengths' or 'Ethernet / SDH' (what these circuits are marked as before this update) are used in the web msr, therefore I believe this can come out and I have updated it accordingly.


update opsdb_circuit set circuit_usage = 'Ignore' where circuit_absid in (27969,28261,28281,28217,28219,28221,28277,28297,28269,27971,28275,28295,28303,28259,28279,28267,28289,28299,28271,28291,27967,27973,28315,28273,28293,28301,28263,28285,28249,28223,28225,28265,28287);

...