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 = 6;** Pay attention to the year and the month value in the above command.

ORDER 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.

...