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

Please log in to comment

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
Fourth Degree Green Belt

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

Please log in to comment
Answer this question or Comment on this question for clarity

Share