Are your asking to generate an actual report on the list of all devices/nodes including interfaces that are using NTA application? and what data are they collecting?
Do you mind telling the version of your NTA?
Thanks for getting back to me. I am working with SVBank on this analysis.
I need to audit all of the NetFlow Sources that are reporting to NetFlow to ensure that we are getting all of the devices reporting correctly and also see what version of NetFlow is on the router/switch.
Is the database schema available for the NetFlow database fields so that I can see all of the reporting fields available? This is the first of many audits that I need to do.
All Router details
Status up or down
Machine type, etc
All Interface details
Type of service
I need to use the Report writer for this type of detain and then I need to export this to a spreadsheet for analysis.
This is a learning experience for me, and I need to understand all of the various database fields that I can access for the report writer.
Once I have this first one I can probably do it on my own.
You can do it via Orion Report Writer. When you choose new report, you can use Current Node, Interface Status. This should bring your those information except "netflow version" and any other information on netflow.
That SQL tab will only appear if the Report Template is "Advance SQL" template. Check on New report >> Advance SQL.