/build/static/layout/Breadcrumb_cap_w.png
09/03/2019 121 views

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.

0 Comments   [ + ] Show comments

Comments



Community Chosen Answer

1

(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 
FROM MACHINE
JOIN MACHINE_NICS on MACHINE_NICS.ID = MACHINE.ID
WHERE MACHINE_NICS.NIC like '%Intel%Wireless%'

To use this code:

  1. Create a smart label using any criteria

  2. View the smart label details

  3. Click the Edit SQL button

  4. Continue through the warning if prompted

  5. Delete the SQL code generated by the wizard

  6. Paste the above code into the query box

  7. Save

You can also use that code as a report.

Answered 09/05/2019 by: chucksteel
Red Belt

All Answers

0

create a CIR under software

"ShellCommandTextReturn(cmd /c WMIC nic get Name)"

then use a filter "contains" on that return to report on

Answered 09/04/2019 by: SMal.tmcc
Red Belt