Netflow inventory report

Ok my issue is a bit different. I need to write a report that shows the nodes and interfaces that netflow are sending netflow to NTA. We're basically trying to see what we have turned on what we need to turn on or off. Any one have any ideas

Find more posts tagged with

cbqos_reports_with_pre-_and_post-_policy

netflow_inventory_report

Accepted answers

davzak

You can start Advanced Report with SQL command like:

SELECT Nodes.Caption, Interfaces.Caption

FROM
NetflowSources
INNER JOIN Interfaces ON (NetFlowSources.InterfaceID = Interfaces.InterfaceID)
INNER JOIN Nodes ON (Nodes.NodeID = Interfaces.NodeID)

All comments

mcbridea

You would have to write a custom SQL report. If you are a SQL guru or know one here is that table you would use.

NF Sources.jpg

davzak

You can start Advanced Report with SQL command like:

SELECT Nodes.Caption, Interfaces.Caption

FROM
NetflowSources
INNER JOIN Interfaces ON (NetFlowSources.InterfaceID = Interfaces.InterfaceID)
INNER JOIN Nodes ON (Nodes.NodeID = Interfaces.NodeID)

jeffnorton

Thanks. Since this is mainly a rare event need, just accessing the table and printing as is will do for my needs

mendan137

Excuse me Davzak.

Do you know how Can I execute a SQL command to extract CBQoS Drop?

I need to do a report monthly with the CBQoS Drop packets of all Interfaces.

And also about the Pre-Policy Class and Post-Policy.

I appreciate your help.

Regards.
Daniel Mendoza.