Is there a kace report that will list by windows server in inventory what is given when you click on Patched in Deployment Status.I have over 100 windows servers that I need to check in see what patched was installed and the date. Thanks for your help.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Hey cosseboomm,

Is this what your looking for?
SELECT Concat(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) AS MACHINE_NAME,
MACHINE.OS_NAME,
P.TITLE AS DISPLAY_NAME,
P.IDENTIFIER AS KB_ARTICLE,
IF(S.DEPLOY_STATUS_DT LIKE '000%', ' ', S.DEPLOY_STATUS_DT) 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 MACHINE.OS_NAME LIKE '%SERVER%'
ORDER BY MACHINE_NAME,
P.TITLE
Answered 12/22/2010 by: dchristian
Red Belt

Please log in to comment
0
Thanks that helps very much also received this from kace support
Thanks again


Select
Concat(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) As MACHINE_NAME,
P.TITLE As DISPLAY_NAME,
P.IDENTIFIER As KB_ARTICLE,
S.STATUS_DT,
MACHINE.OS_NAME
From
PATCHLINK_MACHINE_STATUS S,
MACHINE,
KBSYS.PATCHLINK_PATCH P
Where
MACHINE.ID = S.MACHINE_ID And
S.PATCHUID = P.UID And
(MACHINE.OS_NAME Like '%server%' And
S.STATUS = 'PATCHED')
Order By
MACHINE_NAME, P.TITLE
Answered 12/22/2010 by: cosseboomm
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share