8.3 Workflow Summary

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.

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.

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

*** 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