Comments
-
Hello, It seems that Indexes were partially fixed. The rebuild process starts from the latest day and process days in sequence. It seems several of your latest days were already fixed, that's why you have correct results when you use (GetUTCDate() - 2.5). I think all new flows will be in correct indexes from no one. So,…
-
Hello, Sure, hope it helps. Please update the thread after verification, I would like to know the results. Thank you.
-
Hello, Yeah, that's what I needed. It looks like the query propagated from SWIS to FastBit is correct. I think the problem can be because of corrupted indexes on FastBit. I can suggested to contact SW support or try to rebuild indexes yourself. To do so, you need to open FastBit Studio again and execute next query EXEC…
-
I think you misunderstood me. You need to execute query in SWIS Studio SELECT [flow].[TimeStamp], [flow].[ApplicationID], (SUM([flow].[EgressBytes])/60) AS eBytes, (SUM([flow].[IngressBytes])/60) AS iBytes, (SUM([flow].[TotalBytes])/60) AS TotalBytes FROM Orion.NetFlow.Flows AS flow INNER JOIN Orion.Netflow.Applications AS…
-
Yeah, I tried to scroll down, and it works fine. But I don't have a lot of data in first place. Can you try to do following steps: 1. Run application on your FastBit server c:\Program Files (x86)\SolarWinds\Orion\NetFlowTrafficAnalysis\SolarWinds.NetFlow.FastBit.Studio.exe (it will warn you, but you should not execute any…
-
Are you sure that the screenshot and query are matching? There should be the Name column in 3rd position, but it's not shown on screenshot. I tried the query on my environment, and it works perfectly fine. But that may depend on the version of NTA as well. I tried it on NTA 4.1.1 RTM and NTA 4.2 RC1 and it works correctly.…
-
Hello, I'm not sure why exactly you get strange results. If you could provide result query with several appId filters, then I could tell you more. However, there are couple of things, that can be improved: First of all, it's important to put TimeStamp condition as the first condition in WHERE statement. This will…