Versions Compared

Old Version 6

changes.mady.by.user Emma Apted

Saved on

compared with

New Version 7

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_dante_service_volumes
WHERE (excel_yearly_dante_service_volumes.project='GEANT2')
AND (excel_yearly_dante_service_volumes.circuit_usage='Access')
AND (excel_yearly_dante_service_volumes.type='ipv6')
AND (excel_yearly_dante_service_volumes.period>period >= '"+ConcatPeriodFrom+"')
AND (excel_yearly_dante_service_volumes.period<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;

...