Systems Management Question
Smart Label Help
KACE Systems Management Appliance K1000.
Am needing to ID all laptops in my environment that contain Intel Dual Band Wifi NICs so we can push Intel's new driver to them via an msi
How would I create a Smart Label to acheive this? I can't find anything that would point to a NIC in the first dropdown field.
Community Chosen Answer
(Also posted this on Reddit https://www.reddit.com/r/kace/comments/cz9234/smart_label_help/)
Here is the SQL query you can use for that:
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE_NICS.NIC, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID
JOIN MACHINE_NICS on MACHINE_NICS.ID = MACHINE.ID
WHERE MACHINE_NICS.NIC like '%Intel%Wireless%'
To use this code:
Create a smart label using any criteria
View the smart label details
Click the Edit SQL button
Continue through the warning if prompted
Delete the SQL code generated by the wizard
Paste the above code into the query box
You can also use that code as a report.