Is there a way to find out when a node was added. If I wanted to know if a node was added a year ago vs 5 years ago, is there a way to find out? Is that datapoint captured in the Orion Database anywhere?
The easiest way is to pull the first date it was polled from its historical Response Time. It should have a timestamp (ObservationTimestamp) in there for it. You could get it from the database, but you can also get it via a SWQL query if you want.
It depends on how long your data retention is. I believe it's saved as an event, however, it's likely that after 30 days to a year, depending on your data retention, those events would no longer be in the database.
Yep - that's exactly what I thought about first: the audit log, but it has a short retention period normally. But the response time would be kept forever, even if it's summarized down to a single number for a day (as opposed to hourly or detail levels).
I couldn't find a table with ObservationTimestamp that seemed to show the first time a node was seen by the system.
(The oldest date I found was 90 days old, for example in Orion.ResponseTime).
There is a TimeStamp field in Orion.NPM.Nodes though, and as far as I can see it looks to contain the date we are looking for.
Using Solarwinds version 2024.2.1.
One caveat though: it looks like only Cisco switches are represented in the Orion.NPM.Nodes table. No Dell, HP or other brands.
if you need non-network vendors, look in Orion.Nodes instead. That is the main table, contains every node monitored.
