0 Replies Latest reply on Aug 5, 2015 8:00 AM by azabielski

    Question on SWQL and intervals

    azabielski

      So i have this base query for swql to extract netflow data:

       

      select OutTraffic from (SELECT SUM(EgressBytes)*8/60 as OutTraffic, TimeStamp FROM Orion.Netflow.Flows(nolock=true) WHERE SourceIPGroupSegmentID = 629 GROUP BY TimeStamp Order by OutTraffic DESC) where Month(TimeStamp) = '7' and Year(TimeStamp) = '2015'

       

      However I know how to create a 5 min interval , like the custom graph this is on, in MSSQL but not SWQL. Would there be a way with no DATEADD function?