Page History

...

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

in Eclipse run the "Application.java" in the msrgenerator application and then go to the browser "http://localhost:8080/splunk/2018/5/" note the year and month values (these are changeable) . The browser should display "Number of records : XYZNumber"

Once the above step is completed, do the steps below.

** 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 after checking he's done this carry on from here. (This needs to be committed to source control and deployed somewhere)

Run the following SQL command in the reports database (Heidi-SQL) on test-msr.geant.net:

select concat('UPDATE report_service_availability SET outage="',SPLUNK_DATA.outage_time,'", number_of_failures=',SPLUNK_DATA.no_of_failures,', avail=',SPLUNK_DATA.availability,' WHERE base_absid=',opsdb_circuit.circuit_absid,' AND year=',SPLUNK_DATA.year,' AND month=',SPLUNK_DATA.month,';')
FROM SPLUNK_DATA LEFT JOIN SPLUNK_LINK ON (SPLUNK_LINK.ip_address = SPLUNK_DATA.ip_address)
LEFT JOIN opsdb_circuit ON (opsdb_circuit.name = SPLUNK_LINK.circuit_name)
where SPLUNK_DATA.year = 2017
and SPLUNK_DATA.month = 7
and opsdb_circuit.circuit_usage = 'Access'
and opsdb_circuit.status = 'Operational';

...