Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Historical Date for Added Nodes in Orion NPM...

Hello,

We are running Orion NPM for more than 3 years....and I would need to find out the historical date for adding the nodes in the DB for monitoring. Does the application retain such values?

Thanks,

Cosmin

Find more posts tagged with

date

Accepted answers

All comments

I don't believe it does. Nor does it have the date for removing nodes.

In my case I've created a daily 'Node Added' report which I email to myself daily. This is the best I've come up with for my needs. It uses the EVENT LOG schema:

Select NodeName, IP_Address, Event_Time, Cast(Message As nvarchar(250)) as Message, Event_Type_Name From ( SELECT Nodes.Caption AS NodeName,
Nodes.IP_Address AS IP_Address,
Events.EventTime AS Event_Time,
Events.Message AS Message,
Events_EventTypes.Name AS Event_Type_Name

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

WHERE
( EventTime BETWEEN 40418.3989930556 AND 40419.4166666667 )
AND
(
(Events_EventTypes.Name = 'node added')
)

) As r ORDER BY 3 DESC

Quick Links