Hardware inventory collects information about Network Interface Cards (NICs) and the MAC address assigned to each NIC, but there is no out-of-box report to view this information. To view this information with a custom report follow these steps:
In the console go to Reports>All Reports.
Right-click on a report folder or create a new report folder to create the report in.
Select New>Report>SQL Report.
Give the new report an appropriate name.
Delete the default query in the Parameterized Query box and paste the following query:
SELECT vComputer.Name, vComputer.[IP Address], vComputer.[MAC Address], Inv_HW_Logical_Device.Description, Inv_HW_Network_Adapter.[Network Address] FROM Inv_HW_Logical_Device LEFT JOIN vComputer on vComputer.Guid = Inv_HW_Logical_Device._ResourceGuid LEFT JOIN Inv_HW_Network_Adapter on Inv_HW_Network_Adapter._ResourceGuid = Inv_HW_Logical_Device._ResourceGuid AND Inv_HW_Network_Adapter.[Device ID] = Inv_HW_Logical_Device.[Device ID] WHERE Inv_HW_Logical_Device.[Device Class] = '512' AND Inv_HW_Logical_Device.Description NOT LIKE '%miniport%' AND Inv_HW_Logical_Device.Description NOT LIKE '%minipuerto%'
Save the Report and view the results. The search bar can be used to narrow the results down to certain computers.
Please note that Symantec Support does not support custom reports so further modifications and troubleshooting must be made by the user.
Subscribing will provide email updates when this Article is updated. Login is required.