ITNinja

Post what you have, well help with the rest

Here is what I have:

SELECT PP.TITLE AS DISPLAY_NAME,
M.NAME AS ComputerName,
SYSTEM_DESCRIPTION,
M.USER_LOGGED as USER_LOGGED
FROM PATCHLINK_MACHINE_STATUS MS
JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
JOIN MACHINE M ON M.ID = MS.MACHINE_ID
WHERE (MS.DEPLOY_ATTEMPT_COUNT >= MS.MAX_DEPLOY_ATTEMPT and MS.STATUS != 'PATCHED') or MS.STATUS = 'FAIL' or (MS.DEPLOY_STATUS = 'FAIL' and MS.STATUS != 'PATCHED')
ORDER BY PP.TITLE

I think this is getting closer.

You said you wanted to organize by label.

Is that patch label or machine label?

SELECT PP.TITLE AS DISPLAY_NAME,
M.NAME AS COMPUTERNAME,
SYSTEM_DESCRIPTION,
M.USER_LOGGED AS USER_LOGGED
FROM PATCHLINK_MACHINE_STATUS MS,
KBSYS.PATCHLINK_PATCH PP,
MACHINE M
WHERE PP.UID = MS.PATCHUID
AND M.ID = MS.MACHINE_ID
AND PP.IS_SUPERCEDED = 0
AND PP.STATUSID = 'ACTIVE'
AND ( ( MS.DEPLOY_ATTEMPT_COUNT >= MS.MAX_DEPLOY_ATTEMPT
AND MS.STATUS != 'PATCHED' )
OR MS.STATUS = 'FAIL'
OR ( MS.DEPLOY_STATUS = 'FAIL'
AND MS.STATUS != 'PATCHED' ) )
ORDER BY PP.TITLE

Actually, this works great. Thank you.