You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 2
Next »
Here are the queries used to generate each section, as of today:
Total DWS Traffic
SELECT period,year,month,volume_in,volume_out
FROM reports.excel_yearly_volumes
WHERE (excel_yearly_volumes.project='DWS')
AND (excel_yearly_volumes.circuit_usage='Interconnect')
AND (excel_yearly_volumes.period >= '201711')
AND (excel_yearly_volumes.period <= '201810')
ORDER BY period ;