How is the “routable” column from the table Inv_AeX_AC_TCPIP is populated?

Products

• IT Management Suite

Issue/Introduction

QUESTION:

Where does the Agent get the information from that appears in the “routable” column from in the table Inv_AeX_AC_TCPIP?  Is there a registry entry?

REASON FOR QUESTION:

Customer is reporting  issues with servers that have two NIC.  One NIC is routable only to the database and the other is routable to everything else in the production network.    The Inv_AeX_AC_TCPIP table shows the database NIC as routable = 1 and the production network NIC as routable = 0.  If this info is manually changed, it gets overwritten by a basic inventory. This is causing false positive Monitor alerts and incorrect data in vComputer.

Environment

ITMS 7.x, 8.x

Resolution

We set this value by checking the IP address of each local adapter.  If the IP address of the adapter matches the IP address stored in "HKLM\SOFTWARE\Altiris\Altiris Agent\Inventory\IP Address" then the value is
set to 1 otherwise it is set to 0.

 

Note:

If you look at the actual [vComputer] view, the "IP Address" is taken from the [vTcpIpAddress]  view. 

If you look at the [vTcpIpAddress] view, you will see that the IP Address is actually selected mainly by "Routable" and/or "DHCPEnabled" values. So, it still takes the first value ID from "Inv_AeX_AC_TCPIP" table but at least narrows down to only the ones that have "Routable" and/or "DHCPEnabled" values. which gives you a better chance to get the desired IP address from an active NIC.