Report NIC MAC addresses regarless of interface state?
I'd like to have a report of all NIC MAC of all computers, regardless of the NIC connection state.
Currently (K1000 v5.3) when creating a Computer NIC report, the data is inconsistent. Some computers report all NIC, some report only the connected (with an IP assigned) ones and some others report the connected ones + Bluetooth.
Anyone got similar experience? Is it related to an agent setting? System setting? Report query?
For reference is is the SQL statement for the report:
SELECT MACHINE.NAME AS SYSTEM_NAME, MACHINE_NICS.NIC AS NIC,MACHINE_NICS.MAC AS NIC_MAC FROM MACHINE_NICS JOIN MACHINE ON (MACHINE.ID = MACHINE_NICS.ID) ORDER BY SYSTEM_NAME