Page History

The Monthly Service Report (MSR) is a combination of various scripts to obtain and mash network traffic availability and utilisation data. There is a front-end GUI based on Java Server Pages (JSP)

If you examine the /var/lib/tomcat6/webapps/msr/WEB-INF/web.xml file on the server, you will notice that the MSR also uses three Java Servlets:

GraphGenerator (net.dante.msr.graphs.GraphGenerator) - used by the Graph Generation page: http://test-msr.geant.net:8888/msr/ad_graphs.jsp in the Administration section

ExcelExport (net.dante.msr.CSVExport) - used by each page that has the Excel Export icon in it

TrendAnalysis (net.dante.msr.graphs.TrendAnalysis) - used by Individual graph pages: http://test-msr.geant.net:8888/msr/ms_nren_ip_util.jsp and http://test-msr.geant.net:8888/msr/ms_nren_int_util.jsp in the Trend Analysis section 

Every month the data is prepared on test-msr.geant.net (62.40.104.162) and stored within a MySQL database on the same machine. The databases that the MSR uses are called reports and otrs. The MySQL user that is used to access the database is reportsUser. The password is stored within KeyPass

...