Hi,

Is there a way to check from K1000 whether the client computer is having a static or dynamic IP address?

Thanks.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
The data is stored in the MACHINE_NICS table and shown in the Inventory when you expand the Network Interfaces section. Here's a simple report that grabs machines and their MAC, IP and whether DHCP is enabled:
SELECT MACHINE.NAME, MACHINE.IP, MACHINE_NICS.MAC, MACHINE_NICS.DHCP_ENABLED FROM ORG1.MACHINE_NICS
JOIN MACHINE on MACHINE.MAC = MACHINE_NICS.MAC
ORDER BY MACHINE.NAME
;

Since machines can have multiple NICS this will report based on the most recent MAC that the machine was connected with.

Answered 06/27/2014 by: chucksteel
Red Belt

  • Thanks but received the output is inconclusive...not sure is there some setting on K1000 that is causing this outcome:
    Name Ip Mac Dhcp Enabled
    4DTC11S00 10.198.148.237 CC:52:AF:44:74:F1 TRUE

    4DTC11S00 10.198.148.237 CC:52:AF:44:74:F1 FALSE
Please log in to comment
Answer this question or Comment on this question for clarity