Page History

Connect to the reports database on test-msr.geant.net using the user reportsUser and the password that is stored in Keypass (Use MySQL Workbench)

Run the following query:

select * from reports.SPLUNK_DATA
where interface_description like '%VPN%'
and year = 2017
and month = 8
order by interface_description, year, month;

...

Copy the results and paste them into a Microsoft Excel Spreadsheet. Tip: Right-click on the rows in MySQL Workbench, choose "Copy Row (Tab separated)"

In the spreadsheet, delete column A (absid). You will end up with something like this:

Image Added

Study the interface descriptions that should be in column G of the Spreadsheet.

...

In column I of the Spreadsheet, enter either bgp_lu_access_1 or bgp_lu_access_2 depending on the BGP LU Connection Type. See below:

Image Added

In column J of the Spreadsheet paste the following Microsoft Excel Function:

...

Complete the rest of the rows and copy the SQL statements. See below:

Image Added

Connect to the md_vpn database on prod-cacti02.geant.net using the user mdvpnUser and the password that is stored in KeypassLastPass.

Run the SQL statements that you have just copied: (Columns J and K from the Spreadsheet)

Now we need to update the service availability by running the following SQL statement:

UPDATE msr_vpn_availability
SET md_vpn_status = bgp_lu_access_1
where nren_name in ('AMRES','BELnet','BREN','CARnet','CESnet','FCCN','GRnet','HUNGARnet')
and year = 2017
and month = 8;

...