I have a customer who's using a k1000 system and is able to generate reports about critical patches but would also like to generate one for important patches. I don't have any sqlexperiance and was wondering if someone could help me out

Question

Here is the query they sent me:SELECT M.NAME AS MACHINE_NAME,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_PATCHEDFROM PATCHLINK_MACHINE_STATUS MSJOIN KBSYS.PATCHLINK_PATCH PP ON (PP.UID = MS.PATCHUID)JOIN PATCHLINK_PATCH_STATUS PPS ON (PPS.PATCHUID = PP.UID)JOIN MACHINE M ON (M.ID = MS.MACHINE_ID)JOIN MACHINE_LABEL_JT ML ON (M.ID = ML.MACHINE_ID)JOIN LABEL L ON (ML.LABEL_ID = L.ID)WHERE PP.IMPACTID = 'Critical'AND PPS.STATUS = 0AND PP.IS_SUPERCEDED = 0GROUP BY M.NAMEORDER BY M.NAME, PERCENT_PATCHED

Accepted Answer

The possible IMPACTID values in the PATCHLINK_PATCH table are Software, Critical and Recommended. Assuming that by important they mean Recommended you can change this line:

WHERE PP.IMPACTID = 'Critical'

to:

WHERE PP.IMPACTID = 'Recommended'

I have a customer who's using a k1000 system and is able to generate reports about critical patches but would also like to generate one for important patches. I don't have any sqlexperiance and was wondering if someone could help me out

Answers (1)

Posted by:

View more:

Related Questions

Related Links

Related Posts

KACE Product Support

I have a customer who's using a k1000 system and is able to generate reports about critical patches but would also like to generate one for important patches. I don't have any sqlexperiance and was wondering if someone could help me out

Answers (1)

Posted by:

Don't be a Stranger!

View more:

Related Questions

Related Links

Related Posts

Share