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

Tables in SWQL not available in SQL

I am trying to build scripts in SQL, but the NCM.Nodes table is not available. I can access it fine from SWQL. Can someone explain why this is?

Find more posts tagged with

Accepted answers

The schema available in SWQL is not just a copy of the database schema. In this case, the data you are looking for is in the NCM_Nodes table.

All comments

The schema available in SWQL is not just a copy of the database schema. In this case, the data you are looking for is in the NCM_Nodes table.

Adding on to this, you won't get very far at all in doing SQL work against the database without installing SQL Management Studio and connecting it to your database to see whats out there. As a less powerful alternative you can also browse the tables with the Database Manager tool on your main Orion server. I can't imagine how painful it would be to try and write scripts without looking in one of those tools.

Quick Links