Good day.
First of all thanks for all the help from the Thwack community.
I'm working on a data project for my company that pulls select data from routers using a SWQL query.
Question about data collection intervals.
Routers configured for Polling Interval 120 seconds, Statistics Collection 10 minutes (first screenshot)
However, running my query to pull values from the Interfaces table from 'yesterday' time stamp interval is a consistent 9 minutes (second screenshot). BTW first field is simply a label.
Can anyone provide insight how I can get a 9 minute data interval with a 2 minute Polling and 10 minute Statistics collection? I have posted the query used below (obfuscating any company specific data).
Thanks in advance for any insight.
SELECT
i.Node.Caption
,i.FullName
,i.Traffic.DateTime
,i.Traffic.InAveragebps
,i.Traffic.InMaxbps
,i.Traffic.InMinbps
,i.Traffic.OutAveragebps
,i.Traffic.OutMaxbps
,i.Traffic.OutMinbps
,i.Traffic.Averagebps
,i.Traffic.InPercentUtil
,i.Traffic.OutPercentUtil
,i.Traffic.Errors.InErrors
,i.Traffic.Errors.OutErrors
,i.Traffic.Errors.InDiscards
,i.Traffic.Errors.OutDiscards
FROM Orion.NPM.Interfaces AS i
WHERE i.Node.Caption LIKE '%XXXXXX%'
AND i.Traffic.DateTime >= DATETRUNC('day', GETUTCDATE() - 1)
AND i.Traffic.DateTime < DATETRUNC('day', GETUTCDATE())
AND (HOUR(i.Traffic.DateTime) BETWEEN 18 AND 23)
ORDER BY i.Node.Caption, i.FullName, i.Traffic.DateTime
