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!

Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • 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
    • 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')
Please log in to comment

Answer Chosen by the Author

0
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
Answered 10/24/2017 by: n1md4
Orange Senior Belt

  • Thanks n1md4!!
    You saved my skin!!
Please log in to comment

Answers

Answer this question or Comment on this question for clarity
Nine Simple (but Critical) Tips for Effective Patch Management
This paper reviews nine simple tips that can make patch management simpler, more effective and less expensive.

Share