Inv_AeX_AC_TCPIP gets NULL values in some Computer Resources
Last Updated April 20, 2009
The issue was noticed in Resource Manager where some computers have NULL values for the Inv_AeX_AC_TCPIP. Seems that if Basic Inventory is sent from one of the affected machines, the information is populated correctly. After checking Inv_AeX_AC_TCPIP table, it was noticed that NULL entries existed for some resources under the Subnet or the IP Address columns.
Running Altiris KB 28720 fixes the issue temporarily but in some point those resources get NULL values again.
The issue can be due to two major reasons:
1. Having an old version of AeXBasicInventory.dll.
Inventory Solution ships with an older version of AeXBasicInventory.dll than what is included with the NS 6.0 server rollups. See Article ID:
29127 "Primary User Does Not Show in Resource Summary"
2. Using Browse List Resource Discovery. The issue is that the Basic Inventory (or Full Inventory) is able to access a lot more information than the Browse List Discovery, and is therefore more correct. When the Browse List Discovery runs, it will fill the data with what it finds, and when it finds empty data it will fill with a NULL value. This has always been the case and it is not considered a bug.
1. Make sure that you are using the updated version of the AeXBasicInventory DLL as Article ID: 29127 "Primary User Does Not Show in Resource Summary" suggests.
2. Identify when was the last time Inv_AeX_AC_TCPIP table was updated. You can run the following queries to match time stamps:
SELECT*FROM ResourceUpdateSummary WHERE inventoryclassguid ='37974FB9-E60E-4027-B72D-19E3F088A6A5'--Inv_AeX_AC_TCPIP dataclass AND resourceguid ='GUID from an affected machine'
SELECT*FROM Inv_AeX_AC_TCPIP WHERE _resourceguid ='GUID from an affected machine'
3. Normally, there is not much information to identify when the NULL values were added. In order to have more details of when those fields are been modified with NULL entries, enable the Resource History for Inv_AeX_AC_TCPIP. a) Go to Console > Server Settings > Notification Server Settings > Resource History b) Under Basic Inventory, in the main frame, select AeX AC TCPIP with this, you should be able to start keeping the history of this table and be able to see when good data is been added and when NULL are inserted. After you are done troubleshooting, disable the history table so you don’t accumulate unnecessary data. Run this query a day after you enable this resource history for AeX AC TCPIP to check when this table has been modified:
SELECT *FROM InvHist_AeX_AC_TCPIP WHERE _resourceguid ='GUID from an affected machine'
4. Check if you are running a Resource Discovery with the Browse List option checked. If that is the case, disable Browse List and leave Membership option checked. Browse List Discovery is very limited and it will add the NULL values.
5. If Resource Discovery is not the problem, try to identify a pattern of when the NULLs are been added. In this case compare when those values are been added between different machines. You can use this query to identify which ones has NULLs under the Inv_AeX_AC_TCPIP table:
SELECT vc.Name, ip.*
FROM Inv_AeX_AC_TCPIP ip
JOIN vComputer vc on vc.Guid = ip._ResourceGuid WHERE ip.Subnet isNULL
Then choose some of those machines from the results obtained from the query above and
grab the _resourceGuid values for those and replace it on this query:
SELECT *FROM InvHist_AeX_AC_TCPIP WHERE _resourceguid in ( 'GUID from an affected machine', 'GUID from an affected machine', 'GUID from an affected machine', 'GUID from an affected machine' )
This should show when NULLs were added to those machines and verify if there is a time frame in common. If that is the case, check your Schedules and see if there is any that run around that time frame.
Applies To Notification Server 6.0.6074 SP3
Imported Document ID: TECH41721
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe