Idea Details

NFA API for Device that dont send flows

Last activity 05-21-2019 07:26 AM
Marko Popovich's profile image
05-14-2019 01:37 PM

We need to have an API in NFA so we can determine when was the last flow sent to the Device. This way we know what device are no longer on the network and we can prune them out.


05-21-2019 07:26 AM

The 10.0 ODATA API looks promising: http:/$select=RouterAddress,LastData though there seem to be default limits to only return 10 items per query. There is a $groupby option, but apparently no max function, yet. 


select routeraddress,routername,from_unixtime(max lastdata)) from agents_all_view group by routeraddress; 

might be a useful SQL query while ODATA evolves.

05-14-2019 03:52 PM

Right now we have a LastData field for the interfaces, but not the Routers themselves. It would be great if we could utilize the LastData field in the Routers table.