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

JOIN Nodes.NodeID ON Events.NetObjectID or Events.NetworkNode?

Hello!

I'm looking for clarification on the correct way to join the Nodes and Events tables. A few weeks ago I created a report using both tables, and the generated SQL statement joined Nodes.NodeID on Events.NetObjectID. But a couple of days ago I created an Event Log report using ReportWriter 8.5.1, and that SQL statement joined Nodes.NodeID on Events.NetworkNode. I don't remember which version used Events.NetObjectID, but I'm certain it wasn't 8.5.1.

Do different versions of ReportWriter join these tables differently? Or did I misunderstand what was going on when the first report joined on Events.NetObjectID? Thanks in advance for any insight, I appreciate it.

Find more posts tagged with

Accepted answers

All comments

mark_wiggans

The Report Writer has not changed between versions so they shouldn't join tables differently. It may depend on the type of report what is actually joined. In the the first report the Events table NetObjectID will be the InterfaceID in the Interfaces table. Within the Events table the NetworkNode will be the NodeID in the Nodes Table.

BinaryDigit09

That makes perfect sense. Thanks Mark!