Orion Report to display Physical servers only

Bump

I tried this, but it looks like it will have to be an SQL report.  I am not that great with SQL so I will pass this on to a co-worker and see what he thinks....  I'll update if I have anything useful.

Hi,

I appreciate you giving this a go. Thank you!

BUMP

It interesting how tricky it can be to identify the VM's from the physical servers.  Why not just use a custom property?  That would be a quick and easy fix.  Then you can filter on that custom property in your report.

Zak Kahl

Loop1 Systems

Hi Zak,

I'm afraid it's a little trickier than that, since there's close to 5000 servers. Also, NPM already knows what is virtual if you're monitoring the vm's hypervisor.

There is a void in the db which makes it almost impossible to do selective reporting on physical or virtual. If you could just sort physical from virtual servers then that would be a quick and easy feature.

Thanks for the suggestion, though

I gave the report a shot for you. It works in my environment.

SELECT Nodes.NodeID, Nodes.StatusLED, Nodes.Caption, Nodes.CPULoad, Nodes.Vendor

FROM Nodes LEFT OUTER JOIN VIM_VirtualMachines

ON Nodes.NodeID = VIM_VirtualMachines.NodeID

WHERE VIM_VirtualMachines.NodeID IS NULL AND (Nodes.Vendor = 'Windows' OR Nodes.Vendor = 'VMWare Inc.' OR Nodes.Vendor = 'Net-SNMP')

I hid the NodeID using field formatting and grouped the report by Vendor.

Hope it helps some. If is almost there and you just need it tweaked let me know and I will see what I can do.

Hi Jay,

This seems to be working good apart from including our kvm's and stuff that use Net-SNMP. That i can fix.

There is an issue i've spotted and that is VMs that are down are added to the report. I take it that's because a VM has to be pingable to become up and before that happens, Orion VIM won't get the status via the vmware sdk.

I could be mistaken.

I added the “ OR Nodes.Vendor = ‘Net-SNMP’ “ because some Linux servers show up that way, since I got nothing erroneous when I ran the report I left it there.

I would have thought that the report would work whether the VM was up or down, once it is in the VIM_VirtualMachines table. (That is what I use to see if the node is a VM or not.) I could see that a ping only node or a new node that has not been ID’ed by Orion VIM yet might not be in that table and thus not in the report right.

I will play with some test nodes and see if I can find out what I am missing to get them all to show up.

Thank you Jay, it is greatly appreciated!