How to check if the client is having dynamic or static IP address
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
9 years ago
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.
Comments:
-
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 - BHLim 9 years ago
