This is a follow up report to my post yesterday, K1000 Report of Critical Patches deployed grouped by Vendor

I wanted the detail as well to delve into our delivery issues and make sure we are patching as effectively as possible.

Here is what I came up with:

Title: Patches with un-patched systems by number of un-pactched systems

Category:Patching

Description: Lists Critical Patches grouped by vendor ordered by most requiring patch.

Output Types: HTML: CSV: TEXT:

SQL Select Statement:
Select P.VENDOR AS 'Crtitical Patches by Vendor',
P.TITLE as TITLE,
COUNT(CASE WHEN S.STATUS='NOTPATCHED' THEN S.MACHINE_ID END) as UNPATCHED
from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P, PATCHLINK_PATCH_STATUS PS
where
MACHINE.ID = S.MACHINE_ID and
PS.PATCHUID = P.UID and
S.PATCHUID = P.UID and
P.IMPACTID like "Critical" and
P.IS_SUPERCEDED = 0 and
PS.STATUS=0 and
S.STATUS='NOTPATCHED'
group by P.UID
order by P.VENDOR, UNPATCHED DESC

Break on Columns: Crtitical Patches by Vendor