I am trying to write a report that show which devices and not sending flow filtering by current date. Can someone help me?
I'm not sure if you have any NetFlow devices that are not exporting flows to test this so let me know whether the following works for you.
select n.caption, fullname, lasttime from nodes n inner join interfaces i on n.nodeid=i.nodeid inner join netflowsources nf on i.interfaceid = nf.interfaceid where convert(varchar(10),lasttime,101) <> convert(varchar(10),getdate(),101)
I'm stilling learning SQL as I go so hopefully someone can correct me if I'm way off base here.
To clarify. I am trying to create a report that shows which devices are not sending flows to orion. I would like for the report to show the Device Name and the last time a flow was received by that device, but i want to filter it by current date. As any device that does not have the last flow update = current date, display in the report.
I do have the shell of the report created, and it shows all devices and the last flow update, but i don't know SQL enough to make it pull current date and time.
I dont have any at the moment, but the circuits drop like flies so i will be able to test it soon. I will let you know. Thanks.
Yep. It worked. Thanks again.
