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