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
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
n1md4
7 years ago
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 7 years ago
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 7 years ago
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 7 years ago