Page History

...

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