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.
select
--VM.Name,
--VM.PowerState as PowerState,
NodeType=CASE VM.PowerState
WHEN 'poweredOn' THEN 'Virtual'
Else 'physical'
END,
node.Caption,
node.MachineType,
Hardware.AgentVersion,
hardware.Manufacturer,
hardware.Model,
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' )
