UPDATE ......From Tuesday 8 April 2025 we have changed the way that Single Sign-on works on this wiki. Please see here for more information:
Update
...
Use MySQL Workbench to connect to reports database on test-msr VM. Or connect via the Putty session (while on test-MSR) using this line "mysql -u reportsUser -p reports". Look in KeePass for passwordThis 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
...