Question:
I am working with Orion Platform 2015.1.3, IVIM 2.1.1, QoE 2.0, NCM 7.4.1, NPM 11.5.3, VNQM 4.2.3, NTA 4.1.2
My goal is to produce something like below - obtained from another (competing) product.
Those input and output interface columns are what I am most interested in.
They are the snmp index values obtained from running "show snmp mib ifmib ifindex" on the Cisco router supplying the netflow.
Is the generation of a similar report via Solarwinds/NTA possible?
Hi,
Such report is possible by using custom SWQL query, as NTA does not store its data in the SQL Database.
SELECT TOP 100 FBIP.SourceIP, FBIP.Port, FBIP.DestinationIP, FBIP.IngressInterface.Index AS [Input Interface], FBIP.EgressInterface.Index AS [Output Interface]
FROM Orion.NetFlow.FlowsByIP AS FBIP
Apologies for not populating all the columns in the query, but I lack of access to an Orion installation right now.
I would strongly suggest to download SWQL Studio to prototype your query before going for the custom report: GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in Powe…
PS: make sure you filter the results with TOP X or by date (something like 'WHERE TimeStamp>GetDate()-1') or you may end up spending a lot of time while waiting for the results to come back.
Prosperon - UK SolarWinds Partners
Installation | Consultancy | Training | Licenses
