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

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.

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

  • No labels