1 Reply Latest reply on Nov 13, 2009 9:07 AM by jtimes

    When was an object first discovered and placed into Orion's database?

    lchance

      Is there a field or anything to show the date and time when an object (like a node) was originally discovered and entered into the Orion SQL database? Thanks.

        • Re: When was an object first discovered and placed into Orion's database?
          jtimes

          Yes there is, but it depends on just how long you retain Events, if its in yours or not.

          It is in the Events table with and EventType=9  (Node Added)
          Look in the EventTypes table to see the descriptions for the event numbers

          Here is a SQL to show all Nodes added in the last 30 days

          ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

          SELECT Nodes.NodeID AS NodeID,
          Events.EventTime AS Event_Time,
          Nodes.VendorIcon AS Vendor_Icon,
          Nodes.Caption AS NodeName,
          Nodes.IP_Address AS IP_Address,
          Nodes.Location AS Location

          FROM
          Nodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)


          WHERE
          ( EventTime BETWEEN 39195 AND 39226 )
           AND 
          (
            (Events.EventType = 9)
          )

           

          ORDER BY 2 DESC