/build/static/layout/Breadcrumb_cap_w.png

Kace 1100 patching report

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

Answers (2)

Posted by: dchristian 13 years ago
Red Belt
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
Posted by: cosseboomm 13 years ago
Senior Yellow Belt
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ