Hardware Inventory MAC address 1

[Chopsy666]

Hi Guys,

Does anyone know what query i should have so that the results from the HArdware inventory database show only the MAC address of the physical NIC in the machine, at the moment im getting 2 or 3 results per machine even though they have only one NIC.

Regards

 

[GerhardR]

Hi!

I think you've used "Network Adapter".
Try "System Resource" - and there "Mac Addresses".

Here the statement:

select distinct Name, MACAddresses from SMS_R_System


Does it work?

 

[Chopsy666]

Brilliant! That worked a treat!

Thanks GehardR