You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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;

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

  • No labels