Versions Compared

Key

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

...

** WARNING Excel cannot handle hour values that are greater than 23, so when you paste the results into your favourite MySQL tool, you will have to get rid of the ` character in front of the first digit for all hour values greater than 23.

Run the amended queries.

** There is a table within the reports database called SPLUNK_LINK, this links the IP Address of the results to the Circuit Name within OpsDB. This table could get out of date as Operations add more circuits.

Currently RL runs a Java application that does the above, so carry on from here. (This needs to be committed to source control and deployed somewhere)

...