/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Patch report - Patch detection not enabled on device

01/20/2015 4216 views

I've been attempting to build a report via the Wizard that will show me a list of machines that have "Patch Detection is not enabled for this device" listed in the Security section below Patching Detect/Deploy Status.  For example:

 f3Osgl.jpeg

I have browsed through topics and subtopics in the wizard but I have yet to be able to hit on what I'm looking for. Is there a way to weed this information out of Kbox?

 

Thanks!

0 Comments   [ + ] Show comments

Comments


All Answers

0
This may not work for your purposes, but here is a query which will return machines that are not included in any enabled patch schedule (regardless of what the schedule(s) actually does).

select *
from MACHINE
where
MACHINE.ID not in (
select M.ID
from MACHINE M
inner join MACHINE_LABEL_JT MLJT on MLJT.MACHINE_ID = M.ID
inner join LABEL L on L.ID = MLJT.LABEL_ID
join PATCHLINK_SCHEDULE_LABEL_JT PLJT on PLJT.LABEL_ID = L.ID
join PATCHLINK_SCHEDULE PS on PLJT.PATCHLINK_SCHEDULE_ID = PS.ID
        join IM_CRON on IM_CRON.ID = PS.IM_CRON_ID
where IM_CRON.ENABLED = '1' )

Answered 10/05/2015 by: JasonEgg
Red Belt

0
I have this same situation, somebody knows how to fix?
Answered 09/20/2015 by: paulhdez
White Belt

 
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