Page History

...

SELECT * FROM reports.msr_ticket_data
WHERE year = 2017
AND month = 6;

** Pay attention to the year and the month value in the above command.

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 

...