Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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)