Attempting to summarize all monthly bandwidth for Transmitted bytes, Received bytes and total Transmit/Received bytes.

ljjernstadt

SELECT [data].[DisplayName] AS [DisplayName]
     , [data].[Node].[DisplayName] AS [DisplayName1]
     , [data].[Traffic].[ObservationTimestamp] AS [ObservationTimestamp]
     , [data].[InstanceSiteId] AS [InstanceSiteId]
FROM orion.npm.interfaces AS data
WHERE (
          (
               (([data].[CustomProperties].[INT_TYPE]) = ('MPLS'))
               OR (([data].[CustomProperties].[INT_TYPE]) = ('Internet'))
               )
          AND (
               NOT (WeekDay(toLocal(([data].[Traffic].[ObservationTimestamp]))) = 6)
               AND NOT (WeekDay(toLocal(([data].[Traffic].[ObservationTimestamp]))) = 0)
               AND NOT (([data].[Traffic].[ObservationTimestamp]) < AddSecond(36000, DateTrunc('day', toLocal(([data].[Traffic].[ObservationTimestamp])))))
               AND NOT (([data].[Traffic].[ObservationTimestamp]) > AddSecond(79200, DateTrunc('day', toLocal(([data].[Traffic].[ObservationTimestamp])))))
               )
          )
WITH NOLOCK

[View:/cfs-file/__key/communityserver-discussions-components-files/46/Monthly-bandwidth-report.xml:640:480]

ljjernstadt

the problem is wrapping up all the interfaces into a single bandwidth summary for each field
Our management wants to see how much bandwidth we are using per the two interface in question
Wrapped up into a monthly basis