Page History

...

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

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