Is there any way to search in K1000 for Devices by Network Interface?
As of right now, under Inventory --> Devices, you can only search for PCs based off of the connected MAC address and IP. However, what if we wanted to search for a Wireless MAC address that isn't currently connected (but inventoried). Is there a way to search by one of the Network Interfaces for a PC?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
7 years ago
You will have to use a SQL report:
SELECT * FROM ORG1.MACHINE
JOIN MACHINE_NICS on MACHINE_NICS.ID = MACHINE.ID
WHERE MACHINE_NICS.MAC = "78:4F:43:9A:9B:0E"
