KACE Product Support Question

Patch compliance report help k1000 version 8.0

Hi all the report below seems to be returning all kinds of patches that are not installed for each host in the device label. I was wondering if someone could help me modify it so I get only the following patches reported on in the format this one gives me:

The patching parameters I would like returned are:

release date within the last 30 days and

superseded = no and

type=security

The report below seems to have some of those but it's really returning just everything that needs to be installed. I'm not sure why.

SELECT M.NAME AS MACHINE_NAME, M.ID,

OS_NAME AS WINDOWS_VERSION,

SUM(MS.STATUS='PATCHED') AS PATCHED,

SUM(MS.STATUS='NOTPATCHED') AS NOTPATCHED,

ROUND((SUM(MS.STATUS='PATCHED')/(SUM(MS.STATUS='PATCHED')

+SUM(MS.STATUS='NOTPATCHED')))*100,0) AS PERCENT_PATCHED

FROM MACHINE M

LEFT JOIN PATCHLINK_MACHINE_STATUS MS ON (M.ID = MS.MACHINE_ID)

LEFT JOIN KBSYS.PATCHLINK_PATCH PP ON

(MS.PATCHUID = PP.UID AND PP.IMPACTID = 'Critical'

AND RELEASEDATE between DATE_SUB(NOW(),INTERVAL 30 DAY) and DATE_SUB(NOW(),INTERVAL 1 DAY)

Comments

Community Chosen Answer

I found a report on here that I was able to use successfully to do something like what you are doing. The first step is to create a Smart Label with the filters you are looking for. Then Here is SQL code for a report that searches based on that Smart Label:

Share

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