Video Screencast Help

Inventory - Network Card

Created: 12 Dec 2013 • Updated: 13 Dec 2013 | 4 comments
This issue has been solved. See solution.

I need to report on network card make and model.  I know this data exist but wonder where it is in the DB.


Operating Systems:

Comments 4 CommentsJump to latest comment

Igor Perevozchikov's picture

Hi jlawson,

If you meant about basic inventory data and don't about Inventory Solution data, then probably this will be useful ►

SELECT [Host Name], [MAC Address], [IP Address], [Device] FROM Inv_AeX_AC_TCPIP
Order by [Host Name]





iddqd idkfa idclip

jlawson's picture

IP thanks as this is not perfect it appears to be the best I can get.  Not sure why a Basic Inventory would provide adapter type but I'm glad it does.


Would be nice to have inventory on ALL adapters but this is atleast something!  Thank you


All adapters would probably require a custom inventory.

Igor Perevozchikov's picture

At least you can install Altiris Inventory Agent on your client computers and perform "Collect Full Inventory" task then you will have such information about NIC in "Inv_HW_Network_Adapter"NIC_Data_0.JPG


iddqd idkfa idclip

jlawson's picture

Igor I also looked at this table before but without doing a join of some sort I'm not sure this data is helpful.  It is possible there is something that can be joined that is keyed to the deviceID or Adapter Type ID but otherwise this table is useless.


There does not seem to be enough values in Adapter Type ID to define each Adapter Model.