Page History

...

connect to reports database with user reportsUser "mysql -u reportsUser -p reports", look in KeePass for password

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

...