How to get the date node was added to Solarwinds using sql?

sgebel

Hi I was asked by our support teams for the information about when some specific nodes (based on their names) were added to the Solarwinds monitoring... I run some queries to get the list of nodes from

.[dbo].[NodesData], but I am not able to find the information when they were added... Please help! Is there such an info in the SW DB? if yes - which table is it...?

mike1843

This data is stored in the Audit Tables.  If you navigate to the Events View (By Default, it's under the home menu), you can filter by the event type of "Node Added" and by the device name.  If you want to use SQL, the following Query will get you the date added:

Select NodesData.Caption, Events.EventTime, Events.Message

from Events

Inner Join NodesData on (Events.NetworkNode=NodesData.NodeID)

EventType=9 and NodesData.Caption like '%nodename%'

If you want to find the add and removal date of any node, the following query will work:

Select EventTime,Message

From Events

Where EventType in (8,9) and Message like '%nodename%'

Don't forget to replace nodename with the name of the node you're searching for.