KACE Product Support : KACE Label or just search based on Network Interfaces?

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 [ + ] Show comments

You can as there is a MACHINE_NICS table in the DB. You just have to try the wizard or connect and write your own SQL statement. - nshah 11 years ago
Here is my SQL search: SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE ((MACHINE.NIC like '%mini%'))

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? - jharrell 11 years ago
We are on 5.5 btw. And this is the information I'm needing to gather from the inventory page / network interfaces:

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. - jharrell 11 years ago
Try. just change the LIKE statement.

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%' - nshah 11 years ago
No go on that one either. Its pulling random pcs. Even after changing the LIKE to '%mini%' - jharrell 11 years ago

Be the first to answer this question

Answer this question

question