/build/static/layout/Breadcrumb_cap_w.png

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.


0 Comments   [ + ] Show comments

Answers (2)

Posted by: chucksteel 1 year ago
Red Belt
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_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.

Posted by: SMal.tmcc 1 year ago
Red Belt
1

create a CIR under software

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

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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ