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 that shows number of Physical versus VM servers

I'm trying to create a report that shows Physical versus VM Support basically sent me to the forums and said probably have to use SQL for this. Can anyone help with just a basic report for this to show number of physical versus number of VM's?

Find more posts tagged with

Accepted answers

All comments

mressler

I was able to create a report using this SQL

declare @TotalCount real

select @TotalCount = count(*) from
(select nodes.caption, nodes.Vendor, case when vm.hostnodeid is not null then 'VM' else
(case when nodes.vendor = 'VMware Inc.' then 'ESX Host' else 'Physical' end)end as IsVM
from nodes nodes
left join VirtualMachines VM
on VM.NodeID=nodes.NodeID
where Nodes.Vendor in ('', 'Windows', 'net-snmp', 'Linux', 'VMware Inc.')) a

select a.IsVM, count(*)/@TotalCount as Total, count(*) as TotalServers from
(select nodes.caption, nodes.Vendor, case when vm.hostnodeid is not null then 'VM' else
(case when nodes.vendor = 'VMware Inc.' then 'ESX Host' else 'Physical' end)end as IsVM
from nodes nodes
left join VirtualMachines VM
on VM.NodeID=nodes.NodeID
where Nodes.Vendor in ('', 'Windows', 'net-snmp', 'Linux', 'VMware Inc.')) a
group by a.IsVM

Aaron748

Did you ever find a solution for this? I'm in the same situation. Still getting same error message. Emory Healthcare Patient Portal

2headedogre

There is a field called Hardware in the Node details and it displays Physical when the devices are not VMs. I cannot find that field to make a report. That would be the easiest solution, just pull all physical Hardware in a report. It must be in a separate table that I do not know how to access.