5 Replies Latest reply on Dec 29, 2009 10:38 AM by r0berth1

    New Report

    r0berth1

      I am trying to write a report that show which devices and not sending flow filtering by current date. Can someone help me?

        • Re: New Report
          r0berth1

          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.

          • Re: New Report
            r0berth1

            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.

              • Re: New Report
                qle

                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.