Query for node date added/discovered

11/1/2018 6:14 PM

9/15/2020 10:38 PM

This article provides a query that can be used to determine when a node is added or discovered.

Notes:

• Event Type for node added is 9. This can be found in the EventType Table.
• Query will use Caption from the NodesData table.
• Data can only be retrieved depending on the Events Retention settings.
  Example: Events Retention default settings is 30 days. If you are running this query 30+ days after the node is known to have been added, there will be no data/result.

Network Performance Monitor

1. Launch Database Manager > New Query.
2. Run the following query:

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   
   Select NodesData.Caption, Events.EventTime, Events.Message
   from Events
   Inner Join NodesData on (Events.NetworkNode=NodesData.NodeID)
   Where EventType = '9' and NodesData.Caption = 'nodename'

Sample Query: