SWQL result is not showing correctly for Interface History Report Interval 15 Minutes ?

Question

Hi All,

I have some issue, i created SWQL script to collect static interface every 15 minutes and it works but the problem is it not showing the result till the last time i executed the script.

Example : Now its 8:53 PM SGT here, and when i execute the script, the last report should be 8:45 PM, instead its only showing 1:00 PM

Is there any issue with my script, or anything to be fixed.

Appreciate for your response.

Thanks

SELECT downsample(H.DateTime ,'00:15:00') as [Timestamp], 
N.Caption as [Device Name], I.Caption as [Interface Name], I.inBandwidth as [Bandwidth],
avg(H.InAveragebps) as [AverageIn],
avg(H.OutAveragebps) as [AverageOut]

FROM Orion.Nodes N
INNER JOIN Orion.NPM.Interfaces AS I 
ON N.NodeID = I.NodeID
INNER JOIN Orion.NPM.InterfaceTraffic AS H 
ON I.InterfaceID = H.InterfaceID

WHERE
(N.Caption = 'Device Name' AND I.Caption = 'WAN Link')

GROUP BY 
N.Caption, I.Caption, I.inBandwidth, downsample(H.DateTime,'00:15:00')

bobmarley · Accepted Answer

Try this

SELECT tolocal (downsample  (h.DateTime ,'00:15:00')) as [Timestamp],

I also put this at the bottom of the query

Order By Timestamp DESC

bobmarley · Accepted Answer

Try adding the time you want within the query in the Where Clause. An example below. Below will only show the past hour.

WHERE N.Caption LIKE 'DEVICENAME' AND I.Caption LIKE 'INTERFACENAME' AND h.DateTime > ADDDATE('Hour', -1, GETDATE())