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.
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
Hi, I am getting no results for this query? Is there something else that should be included. I'm using this via a report. Thank you!
