Note down the total number of opened tickets from this link: http://test-msr.geant.net:8888/msr/ms_new_tickets.jsp and the total number of closed tickets from this link: http://test-msr.geant.net:8888/msr/ms_closed_tickets.jsp

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 here

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

The carried forward tickets for the current month = (The number of brought forward ticket of the current month + The number of opened tickets for the current month) - The number of closed tickets for the current month

Create a new row in the database table reports.msr_ticket_data with the new figures.

*** Insert typical SQL query here

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

*** Once you have completed this stage, you can create the Ticket Analysis graph from this URL: http://test-msr.geant.net:8888/msr/ad_graphs.jsp