...
** 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)
...