Page History

...

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 = 201706;

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

...