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.
Answers (2)
(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_IDFROM MACHINEJOIN MACHINE_NICS on MACHINE_NICS.ID = MACHINE.IDWHERE 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
Save
You can also use that code as a report.
create a CIR under software
"ShellCommandTextReturn(cmd /c WMIC nic get Name)"
then use a filter "contains" on that return to report on
