I am trying to write a report that show which devices and not sending flow filtering by current date. Can someone help me?
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'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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.