/build/static/layout/Breadcrumb_cap_w.png

Device labels for patched devices

Hey guys!

We have an issue with a Windows patch and we have trying to identify the machines with the patch and assign it a device label so that we can run a script against the affected devices. But it doesn't seem to be straight forward. Any help would be greatly appreciated!


1 Comment   [ + ] Show comment
  • You will need a SQL based Smart Label, to cross two different tables. (Patches vs. Devices).

    See this post, I think it's similar request\inquiry
    http://www.itninja.com/question/how-to-create-device-smart-label-from-a-patch-smart-label - Channeler 6 years ago
    • Much thanks for the response Channeler! Fortunately n1md4's suggestion worked for me but I see value in your suggestion.

      I did SQL query and it workied in MySQL but not as a label. What else do I need to do?

      SELECT
      PP.TITLE AS PATCH_NAME,
      M.NAME AS COMPUTER_NAME,
      OS_NAME AS WINDOWS_VERSION,
      OS_BUILD AS WINDOWS_BUILD,
      DATE_FORMAT(PP.RELEASEDATE, '%Y-%m-%d') AS RELEASED
      FROM
      PATCHLINK_MACHINE_STATUS MS
      JOIN
      KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
      JOIN
      PATCHLINK_PATCH_STATUS PPS ON PPS.PATCHUID = PP.UID
      JOIN
      MACHINE M ON M.ID = MS.MACHINE_ID
      WHERE
      MS.STATUS = 'PATCHED'
      AND (PP.IDENTIFIER = 'KB40xxx' OR PP.IDENTIFIER = 'KB40xxx') - egas 6 years ago

Answers (1)

Answer Summary:
Posted by: n1md4 6 years ago
Second Degree Blue Belt
0

Top Answer

Just use advanced search in inventory, computer
software title contains KB123456
Search and then save as smart label

Only works for Patches listed in Device Inventory Patches Reported Installed in Software Inventory

Comments:
  • Thanks n1md4!!
    You saved my skin!! - egas 6 years ago
 
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