Having to make sure that insight manager tools are up to the current versions to be properly managed by Orion. Mostly to get the proper Hardware information I created this script to give me an idea of what versions I was working with. This script also marks Virtual and physical servers so that you can ignore virtual machines.
--VM.PowerState as PowerState,
WHEN 'poweredOn' THEN 'Virtual'
node.DeviceRole as devicerole
from VIM_VirtualMachines as VM
full outer join dbo.Nodes as node on vm.NodeID = node.NodeID
full outer join dbo.APM_HardwareInfo as Hardware on Hardware.NodeID = node.NodeID
where (node.DeviceRole = 'server' )