Report NIC MAC addresses regarless of interface state?
Hello,
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
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
dugullett
11 years ago
Take a look here.
http://www.itninja.com/question/how-to-improve-report-to-get-mac-address-from-client-machine-when-it-does-not-connect
Comments:
-
You can also try modifying your query to group the NICs.
SELECT M.NAME AS SYSTEM_NAME, GROUP_CONCAT(distinct MN.NIC SEPARATOR '\n') as NIC,GROUP_CONCAT(distinct MN.MAC SEPARATOR '\n') AS NIC_MAC
FROM MACHINE_NICS MN
LEFT JOIN MACHINE M ON (M.ID = MN.ID)
GROUP BY M.NAME
ORDER BY SYSTEM_NAME - dugullett 11 years ago
