Page History

Availability data comes from the SPLUNK System as this was deemed more accurate than obtaining network outages from the current Dashboard.

Login to the production SPLUNK instance (https://62.40.104.207:8000/) with your windows credentials.

** RS to check with Evangelos that team can access SPLUNK server 

In the new search edit box, please use the following:

`BGP_Total_Downtime_Percent_v3(*,*,31)`

** Pay attention to the value of the number of days in the month we are processing and the use of the ` character before the B of BGP and after the ) character

Click the Previous Month drop down and select Date Range. Ensure that the to and from date is correct then click the Apply button

Now click the Magnifying Glass icon to start the search. The results appear in the Statistics tab, shown in the image below.

Image Added

Using your mouse, hightlight the rows of the results and copy them to the clipboard. You will only be able to do a page at a time (each page can by up to 100 rows).

Paste your results in an Excel Spreadsheet.

Use this Excel command to create some SQL statements:

=CONCATENATE("INSERT INTO SPLUNK_DATA (year,month,ip_address,no_of_failures,outage_time,availability,interface_description) VALUES (2017,7,'",A1,"',",B1,",'",TEXT(C1,"hh:mm:ss"),"',",D1/100,",'",E1,"');")

** Pay attention to the year and month values in the Excel concatenate command