ITMS 8.5RU2 - SMA push fails to computer with multiple network adapters

Products

• IT Management Suite

Issue/Introduction

Scenario:
* Target computer has one adapter plugged into 10.11.x.x network, another unplugged.
* Push install fails. SMP log shows successful discovery:
===============
Discovered computer details: [<ComputerFQDN>] =>
name=<Computername> (<ComputerGUID>),
domain=SCEE, systype=Win64, os=Microsoft Windows Server 2016 Standard,
version=10.0.14393, fqdn=<ComputerFQDN>  ip={192.0.2.1}
===============
However, SMP is trying to push via IP of unplugged network adapter:
=================
Failed to copy the eXpress Client service to \\169.254.XXX.XXX\ADMIN$\AltirisAgentInstSvc.exe.
Error: The network path was not found.
=================

Failed to copy the eXpress Client service to \\169.254.XXX.XXX\ADMIN$\AltirisAgentInstSvc.exe. Error: The network path was not found.

Environment

ITMS 8.5RU2

Cause

Wrong order of IP addresses returned from database

Resolution

Execute following script against CMDB database to alter stored procedure:

-------------

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

alter proc dbo.spGetDiscoveryMachineInfo
       @resourceGuid uniqueidentifier
as
begin
       -- first set is basic info
       select
              [_ResourceGuid],
              [FQDN],
              [Name],
              [Domain],
              [OS Name],
              [OS Version],
              [System Type]
       from Inv_AeX_AC_Identification a where a._ResourceGuid = @resourceGuid

       -- to join from Agent Push and TCP4 tables
       declare @ips as table ([_id] int not null identity, [IP Address] nvarchar(65))

       -- Agent Push IP
       insert into @ips select [IP Address] from AgentPushData
              where [Guid] = @resourceGuid
                     and [IP Address] is not null
                     and [IP Address] != ''

       -- Inv_AeX_AC_TCPIP
       insert into @ips select t.[IP Address] from (
              select ip4.[IP Address], ip4.[Physical], ip4.[Routable] from Inv_AeX_AC_TCPIP ip4
              left join @ips i on i.[IP Address] = ip4.[IP Address]
              where ip4._ResourceGuid = @resourceGuid
                     and i.[IP Address] is null
       ) t order by t.[Physical] desc, t.[Routable] desc

       -- IPv4
       select [IP Address] from @ips
              order by _id asc
       
       -- IPv6
       select [IP Address] from Inv_AeX_AC_TCPIPv6 where _ResourceGuid = @resourceGuid
              order by [Physical] desc, [Routable] desc
end

-------------