Versions Compared

Old Version 5

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.

...

Total IPv4 Traffic

Code Block
languagesql
2018

Individual IP Traffic

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

Total Interconnect Traffic (R&E Peering)

...