DX Unified Infrastructure Management

We are trying to set up an internal service based on NFA and would like to charge our network teams for this.
Can we get a list of active routers/interfaces that are sending flowdata to harvesters?

If you're simply looking for a list of all interfaces that are sending netflow data to the Harvester, the easiest way would probably be to just run NAST on the harvester machine:

ftp://ftp.ca.com/pub/netqos/supporttools/releasedtools/NASTv13.exe

This will list all interfaces, including ones that are not Licensed.

Thanks Kahlil, I will give it a try.
Does this work on Linux as well (should I extract the files and run the nfaparser script)?

Mark that tool doesn't work on Linux but you can copy over the *.nfa files from the /opt/CA/NFA/NetFlow/datafiles/HarvesterArchive/ directory to a Windows Harvester in a Temp folder.  Then copy the NFAParser/NAST tool to that same folder and run the tool from that directory and it will give you a report based on just those *.nfa files.

I posted a Tech Tip a while back on this as wellech Tip: NFA 9.1 NetFlow Verification on Windows and Linux Harvesters

NetQoS built Allocate to do just that. It handled chargeback based on utilization, but allowed granular control over how much each type of traffic cost etc, etc. Too bad it was discontinued.

There are a couple MySQL queries that could easily give you what you're looking for. It would be better than using a sample of NFA files through the NAST tool.

For example:

select routername, count(*) from agents_all_view where enabled='Y' group by routername;

Will give you a list of routers with the count of interfaces enabled for reporting on that router.

select routername, enabled, count(*) from agents_all_view group by routername, enabled order by routername asc, enabled desc;

Will give you a breakdown of how many interfaces on the router are enabled vs. disabled.

select b.description, count(*) 
from agents_all_view a, harvesters b 
where a.HarvesterAddress = b.address 
group by b.description
order by b.description asc;

Will give you a breakdown per harvester.

If one of these doesn't get you started, give some more details about exactly what you need and I'll see if I can craft a query for you.

To run any of these queries locally on the box, execute

mysql -P 3308 -e "sql_statement"

at the command prompt, where sql_statement is the query to run. You can also connect directly from your service using ODBC or the MySQL DB driver.

Thanks Stuart, this does the trick!

It took me a minute or so to find the right data base to use ('reporter') but now I get all the data i need.

Woops, sorry. Yes: add -D reporter to your command line to specify the correct database to pull from.