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

Report for Virtual Nodes that are missing the backend VM Hosts

I am looking to create a report of Nodes/Systems that Virtual but are missing their backend host

As you can see in this example I know it is a Node in the VMware system by the Model and Manufacturer being VMware, but the Hardware shows as Virtual, host unknown

I have looked thru the database and can not find the tables that has this information

Find more posts tagged with

Accepted answers

All comments

shuth

I can't recall the exact table but one of the Orion.VIM.?? tables in SWQL contains the link between the NodeID and HostID. You could probably put together a query that gives you a list of Nodes where the NodeID is NOT in that table.

eem4osg

In this case it looks like I am missing the VM Host/Vcenter, so I do not think it would be an item in the orion.VIM table.