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 reportsUserr 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

  SET oc.circuit_usage = 'Ignore'

 WHERE

   c.service_type IN ('IP Peering - Non R&E', 'GEANT Open CC');

2- update opsdb_circuit set project = 'Ignore' where name like '% CLS';

Ignore the below section.

=============================================================================================================================================

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

...

-- Emma has confirmed that the above statements should be replaced with

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

  SET oc.circuit_usage = 'Ignore'

 WHERE

   c.service_type IN ('IP Peering - Non R&E', 'GEANT Open CC')

   OR c.name LIKE ('%EEX%');

2- update opsdb_circuit set project = 'Ignore' where name like '% CLS';

-- Cloud services

-- update opsdb_circuit set name = 'DE-US' where name = 'FRA-WIX LAG';
-- update opsdb_circuit set name = 'NL-US' where name = 'AMS-MANLAN LAG';

...

-- Emma thinks that this will be to do with the Interconnects port summary section, this is completely out of date and inaccurate so we are going to hide that section

=============================================================================================================================================