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);

-- Emma to provide a number of queries that will provide the list of absids that should be ignored - Emma's reference 'query A'

--update opsdb_circuit set circuit_usage = 'Ignore' where circuit_absid in (28325,28327,28329,28331,28333,28335,28337,28339,28341,28343,28345,28347,28349,28351,28353,28355,28357,28359,28361,28363,28365,28367,28369,28371,28373,28375,28377,28379,28381,28383,28391,28393,28399,28401,28535);

-- Specifically for 28535 Emma will check separately

Emma has confirmed that the above statements should be replaced with

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%');

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';

-- Update opsdb_circuit set family = 'PC Trail' where circuit_absid in (11727,10805,24285,9233,26211,11841,14917,12497,11397,21091,26555,22959,22883,12511,18693);

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