I am doing a report using SWQL for recv and xmit percent utilization using SWQL for a custom report automation.
While doing this, I noticed a discrepancy on the data and timestamp for both my swql report vs the one I created web based and a custom chart data.
Both Web Based and Custom Chart Data have both the same results. On the other hand, my swql displays wrong data.
Here is my swql code and some screenshots of the discrepancy:
SWQL:
SELECT Top 50 Interfaces.Fullname, DateTime, InterfaceTraffic.InPercentUtil, InterfaceTraffic.OutPercentUtil FROM Orion.NPM.InterfaceTraffic
JOIN Orion.NPM.Interfaces ON interfacetraffic.interfaceid = Interfaces.interfaceid
WHERE Interfaces.customproperties.Report_Property_ReportWriter_ = 'HO Links'
AND Interfaces.FullName = 'KRV05UDC001 - TenGigabitEthernet1/1/28 · POD-MDC [Globe 1Gbps]'
------------------------
VS
------------------------
Custom Chart:
Web Based
