KACE Product Support Question
How to create device smart label from a patch smart label
04/21/2017 2282 views
So we are trying to capture devices that are on the network and are missing old patches. This number changes every day, every hour depending on who is signing on, what new machines are being imaged etc, so a manual label will not work. We current have a smart label created to capture all active patches that are marked as missing on devices and released not within the last 30 days, and if you open that patch label, it shows how many devices fall in to that category. How to we get a label applied to those devices. Essentially how do you apply a patch smart label to a device smart label.
Community Chosen Answer
Please log in to answer
I don't think that this is exactly what you are looking to find, but it might help. This report will find machines that are missing more than 20 patches.
SELECT MACHINE.NAME, MACHINE.ID, COUNT(PMS.PATCHUID) as UNPATCHED
FROM ORG1.PATCHLINK_MACHINE_STATUS PMS
JOIN KBSYS.PATCHLINK_PATCH PP on PP.UID = PMS.PATCHUID
JOIN MACHINE on MACHINE.ID = PMS.MACHINE_ID
WHERE PMS.STATUS = "NOTPATCHED"
and PP.IS_SUPERCEDED = 0
GROUP BY MACHINE.NAME
HAVING UNPATCHED > 20
Answered 04/24/2017 by: chucksteel