Version 1

    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' )