Page History

...

Using either MySQL Workbench or Heidi-SQL review the record of tickets in the previous months report in the table reports.msr_ticket_data and note down the number of carried forward tickets.

*** Insert typical SQL query hereSELECT * FROM reports.msr_ticket_data
WHERE year = 2017
AND month = 6;

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

...

Create a new row in the database table reports.msr_ticket_data with the new figures.*** Insert typical SQL query here

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

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

...