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

Query for when node was added?

Is there a way to determine when Solarwinds added a node for monitoring? We're trying to see if this date is correlating with some issues we're seeing on the server. SNMP crashing that is.

Find more posts tagged with

Accepted answers

MrSampsonite

support gave me the following query which seems to be a decent look. I'm still surprised this is not just a node property. seems pretty basic.

use NetPerfMon

Select n.caption as 'Node Name' , Min(datetime) as DateAdded
from responsetime r join nodes n on n.nodeid = r.nodeid
Group by n.caption
order by n.Caption

All comments

bshopp

How long do you keep events for? Depending on the answer you can look for when this node was added to Orion in there.

MrSampsonite

I don't recall setting or changing that length. So I assume it's the default. Is that somewhere in the NPM settings screens?

I assume that when a node is added, somewhere in sql there's a time stamp even if the event record is not kept.

MrSampsonite

support gave me the following query which seems to be a decent look. I'm still surprised this is not just a node property. seems pretty basic.

use NetPerfMon

Select n.caption as 'Node Name' , Min(datetime) as DateAdded
from responsetime r join nodes n on n.nodeid = r.nodeid
Group by n.caption
order by n.Caption

jbiggley

I know that I am responding to a *very* dated note, but this query is limited by your data retention settings. By default it is 365 days.