Report: Virtual Machine monitored as Node, with Unknown Host

eem4osg

I am looking to create a report of all VMs that are nodes that have the Host as unknow, I am guessing this will be some type of query.

Does anyone know if this has already been created?

Thanks

Seashore

Not entirely sure I understand you correct but here is a query that gives you all nodes that are not found in vmware/hyperv/nutanix but are Windows or Linux

SELECT
    n.Nodeid
    ,N.Caption
    ,N.vendor
    ,N.MachineType
FROM Orion.Nodes as N
LEFT OUTER JOIN Orion.VIM.Virtualmachines as V ON N.nodeid=V.NodeID
WHERE 
    V.NodeID IS NULL
    AND N.Vendor IN ('Windows','Linux')

Below will give you all VM's that don't have any host but that will most likely turn up empty

SELECT
    V.GuestDnsName
FROM Orion.VIM.VirtualMachines as V
WHERE V.HostID IS NULL