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)
Please log in to answer
Posted by:
dchristian
13 years ago
Hey cosseboomm,
Is this what your looking for?
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
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
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.