Orion Table Question

Hi,

I'm trying to identify whether a server in the 'Nodes' table is physical or virtual. Any ideas how to filter the data?

Regards

Matthias

Find more posts tagged with

You could search by vendor

select n.Caption from Nodes as n where n.Vendor like 'vm%'

You could actually do the same thing paste the SQL code in to the report but select the 'advanced Database Query (sql,SWQL) paste bam lol

Thanky for your reply. With "select n.Caption from Nodes as n where n.Vendor like 'vm%'" I get only VM hosts but not all physical servers. :-(

actually you can use the same reports and methods but this might be better for you

select caption, Name, Nodes.NodeID

from VIM_VirtualMachines

inner join Nodes on VIM_VirtualMachines.NodeID = nodes.NodeID