Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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]
ASC

 

Thanks,

IP.

 

  1. Don't forget that, first you can find an answer for your question in Knowledge base
  2. If answer solves your question, then please mark as solution to close a thread
SOLUTION
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

 

  1. Don't forget that, first you can find an answer for your question in Knowledge base
  2. If answer solves your question, then please mark as solution to close a thread
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.