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
===============================
mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL Select Statement:
Select P.VENDOR AS 'Crtitical Patches by Vendor',
P.TIT' at line 1] in EXECUTE(
"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 LIMIT 0") - trouble-shooter 12 years ago
This is built against the 5.3.47927 schema.
Scott - sklauminzer 12 years ago