Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...