Page History

...

Using either MySQL Workbench or Heidi-SQL log into test-msr.geant.net and review the record of tickets in the previous months report in the database table reports.msr_ticket_data and note down the number of carried forward tickets.

SELECT * FROM reports.msr_ticket_dataWHERE year = 2017

AND month = 6ORDER BY absid DESC LIMIT 1;

The number of carried forward tickets from the previous month becomes the number of brought forward tickets of the current month.

...

INSERT INTO reports.msr_ticket_data (period,year,month,brought_forward,opened,closed,carried_forward)
VALUES ('201707',2017,7,999,999,999,999);

** Pay attention to the period, year and the month values in the above command.

Check your results by using the link: http://test-msr.geant.net:8888/msr/ms_summary_tickets.jsp 

...