Versions Compared

Old Version 7

changes.mady.by.user Emma Apted

Saved on

compared with

New Version Current

changes.mady.by.user Emma Apted

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
SELECT period,year,month,volume_in,volume_out
FROM reports.excel_yearly_volumes
WHERE (excel_yearly_volumes.project='GEANT2')
AND (excel_yearly_volumes.circuit_usage='Access')
AND (excel_yearly_volumes.period >= '"+ConcatPeriodFrom+"')
AND (excel_yearly_volumes.period <= '"+ConcatPeriodTo+"')
ORDER BY period;

Individual IP Traffic

Code Block
languagesql
SELECT period,year,month,from_data,to_data
FROM reports.msr_graphical_data
WHERE (msr_graphical_data.period >= '"+ConcatPeriodFrom+"')
AND (msr_graphical_data.period <= '"+ConcatPeriodTo+"')
ORDER BY period;

Total Interconnect Traffic (R&E Peering)

...