The report will need to be: sorted by computer listing showing all patches applied to that particular computer on a certain date.

Example:

Report - Patch Completed on 3/28/2012

WORKSTATION 1
- MSQ 0156-7894 Microsoft Word 2007 Vulernability
- KB 0168135 Microsoft 2012 EOL Patch

SERVER 1
- KB 68435 All your base are belong to us


Any help would be greatly appreciated.

UPDATE: Is there a way to consolidate the computer names if sorted by deploy date? Also is there a way to input = 30 day interval from the currdate?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

4
Here's a modified version of the for each machine report. I think it'll give you the info your looking for.

SELECT CASE
WHEN MACHINE.SYSTEM_DESCRIPTION = '' THEN MACHINE.NAME
WHEN MACHINE.SYSTEM_DESCRIPTION != '' THEN Concat(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION)
END AS MACHINE_NAME,
P.TITLE AS DISPLAY_NAME,
P.IDENTIFIER AS KB_ARTICLE,
IF(S.DEPLOY_STATUS_DT LIKE '000%','Not Installed by Kace',DATE_FORMAT(S.DEPLOY_STATUS_DT,'%Y-%m-%d')) as DEPLOY_DATE
FROM PATCHLINK_MACHINE_STATUS S,
MACHINE,
KBSYS.PATCHLINK_PATCH P
WHERE MACHINE.ID = S.MACHINE_ID
AND S.PATCHUID = P.UID
AND S.STATUS = 'PATCHED'
AND P.IS_APP = 0
ORDER BY DEPLOY_DATE, MACHINE_NAME,
P.TITLE
Answered 03/28/2012 by: dchristian
Red Belt

  • Great report. Thanks for posting.
  • Great! Thanks much. I'll give it a try.
  • Is there a way to consolidate the computer names if sorted by deploy date? Also is there a way to input >= 30 day interval from the currdate? Everything I try says it's wrong and wont run.
Please log in to comment

Answers

0
Is there a way to consolidate the computer names if sorted by deploy date? Also is there a way to input >= 30 day interval from the currdate? Everything I try says it's wrong and wont run. <- Lack of experience here.
Answered 03/29/2012 by: RealityHook
Orange Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Nine Simple (but Critical) Tips for Effective Patch Management
This paper reviews nine simple tips that can make patch management simpler, more effective and less expensive.

Share