Connect to the md_vpn database on prod-cacti02-vie-at.geant.net  use the user mdvpnUser and the password stored in keypass.

In the back-end database, a table called md_vpn.msr_control needs to be updated with the correct year and month. This is acheived using the folowing SQL statement:

UPDATE md_vpn.msr_control
SET year = 2017,
month = 7
WHERE absid = 1;

Tip: you can run this query, it returns one record only. You need to change year and month here: "select * from md_vpn.msr_control;"

** Pay attention to the year and month values in the SQL statement

** IMPROVEMENT - Make this automated by copying the script, http://test-msr.geant.net:8888/msr/ad_roll_report.jsp from the Monthly Service Report application (MSR)