We recently upgraded from NTA 4.2.3 to the latest version of NTA running on 2020.2.4. Prior to the upgrade we generated a bunch of bandwidth reports for clients using the following query.
SELECT SUM(EgressBytes)*8/60 as OutTraffic, TimeStamp FROM Orion.Netflow.Flows(nolock=true) WHERE SourceIPGroupSegmentID = 790
GROUP BY TimeStamp ORDER BY TimeStamp
Since upgrading this query works for some SourceIPGroupSegments and then for others just returns no data. I know that these should have data as I can see the data on the normal Netflow graphs.
I think part of the problem is how the Groups are stored in 2020.2.4 vs how they were back in 4.2.3 along with the changes to the netflow DB(fastbit to SQL) and the introduction to some new IP Group and IP Group Segment tables in SQL.
I need help getting my query repointed in the right direction but I'm just not sure what it needs to look at.