KACE Label or just search based on Network Interfaces?
We are tring to track down all of the laptops that have been deployed over the years in the company that have 3g cards built into them.
With the MANY different images that have been used over time, the only common variable i can find is a Mini-Card listed in the Network Interfaces.
No common software or services running.
Is it possible to create a label or run a sql search to find all machines with 'Mini-Card' listed in the Network Interfaces tab?
5 Comments
[ - ] Hide Comments
Comments
log in to commentThere are no answers at this time
This is the error i get: Please correct the following errors:
mysql error: [1054: Unknown column 'MACHINE.NIC' in 'where clause'] in EXECUTE( "SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE ((MACHINE.NIC like '%mini%')) ")
Any ideas?
Network Interfaces (2)
1) Dw1501 Wireless-n Wlan Half-mini Card:
I'm needing to find all the laptops that contain 'mini' anywhere in the network interface description.
SELECT
MACHINE.`NAME` AS System,
MACHINE_NICS.NIC AS Nic
FROM
MACHINE
RIGHT OUTER JOIN MACHINE_NICS ON MACHINE_NICS.ID = MACHINE.ID
WHERE
MACHINE_NICS.NIC LIKE '%Miniport%'