The Administration sub sections are completed by the Operations team.

Tip: Software Development team needs to do section Generate Graphs below:

Management Summary

The Operations team use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_summary.jsp 

The main MySQL Tables used are: reports.msr_summary_notices

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

Notices

The Operations team use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_notices.jsp

The main MySQL Tables used are: reports.msr_summary_notices

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

Issues

The Operations team use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_issues.jsp

The main MySQL Tables used are: reports.msr_issues

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

Escalations

The Operations team use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_escalations.jsp

The main MySQL Tables used are: reports.msr_escalations

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

New Services Requested

The Operations team use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_new.jsp

The main MySQL Tables used are: reports.msr_summary_notices

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

Point To Point Services

Business Development use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_p2p.jsp

Click the icon indicated by the Red arrow and answer Yes to the question Are you sure you wish to Reload Point-to-Point Services?

The main MySQL Tables used are: reports.msr_p2p_services

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

Upload Topology Diagrams

The Operations team use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_upload.jsp

The images are uploaded to the /var/lib/tomcat6/webapps/msr/media/topology directory on the server.

Check the results by using the links: http://test-msr.geant.net:8888/msr/gi_topology1.jsp and http://test-msr.geant.net:8888/msr/gi_topology.jsp

Generate Graphs

Use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_graphs.jsp

Prior to generating the Interconnect Traffic graph, you will need to run the following query: (Use either MySQL Workbench or Heidi-SQL clients to run the 2 queries below)

1:

SELECT ROUND(volume_in,1) as 'Volume In',ROUND(volume_out,1) as 'Volume Out'
FROM reports.excel_yearly_volumes
WHERE project='GEANT2'
AND circuit_usage='Interconnect'
AND period = 201707;

** Pay attention to the concatenated year and month values in the SQL statement

** WARNING - The above query will not work properly if you have not run all of the queries in the 1.2 General Corrections section

Take a note of the volume_in and volume_out values and then insert a record in the reports.msr_graphical_data table using the following SQL statement:

2:

INSERT INTO reports.msr_graphical_data (period,year,month,from_data,to_data) values ('201707',2017,7, 5675.2,5427.3);

** Pay attention to the concatenated year and month values in the SQL statement

*** The from_data field value should be set to the value of volume_in and the to_data field value should be set to the value of volume_out 

Now, click the Generate Graph button for the following graphs:

Ticket Analysis

NREN Traffic

Interconnect Traffic

DWS Traffic

IPv6 Traffic

LHCONE

INFO: When you click the Generate Graph button, a call is made to the GraphGenerator servlet (net.dante.msr.graphs.GraphGenerator), which constructs the graphs. The generated images are stored in the /var/lib/tomcat6/webapps/msr/media/images directory on the server.

** Warning - Sometimes there is a browser caching issue and you may have to refresh the page (Press F5 button) to see the generated graph appear at the bottom of the page. Or, you might need to restart tomcat on test MSR. Run command: “sudo service tomcat6 restart”

INFO: The main MySQL Tables used are: reports.report_utilization, reports.opsdb_circuit and reports.msr_graphical_data

Check the results by using the links: http://test-msr.geant.net:8888/msr/ms_charts_tickets.jsp, http://test-msr.geant.net:8888/msr/ms_charts_dws.jsp, http://test-msr.geant.net:8888/msr/ms_charts_ipv6.jsp, http://test-msr.geant.net:8888/msr/ms_charts_lhcone.jsp, http://test-msr.geant.net:8888/msr/ms_charts_nren.jsp and http://test-msr.geant.net:8888/msr/ms_charts_interconnect.jsp

Notes

The Operations team use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_notes.jsp

The main MySQL Tables used are: reports.msr_notes

Only certain pages within the system allow notes to be added. In the corresponding Java Server Page (JSP), you will see the follow lines of code in the source:

<!-- start of notes section -->

<%@include file="./display_notes.jsp"%>

<!-- end of notes section -->

At the top of the main JSP script is a variable called scriptTitle, this is used within the display.jsp script, to build the sql statement to retrieve the data from the reports.msr_notes table.

Publish Report

This does absolutley nothing!! 

Roll Report Period

The Operations team use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_roll_report.jsp

The main MySQL Tables used are: reports.msr_control and reports.msr_reports.

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