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

Comments

Please log in to comment

Answers

0

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

Answered 01/08/2013 by: dugullett
Red Belt

  • 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
Please log in to comment
Answer this question or Comment on this question for clarity