Patch report - Patch detection not enabled on device
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:
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!
1 Comment
[ + ] Show comment
-
I'm trying to build same report but with new schema for 10.x. There are no longer PATCHLINK_SCHEDULE table. Does someone have this query working with the new database schema? - tlarue 4 years ago
Answers (3)
Please log in to answer
Posted by:
tlarue
4 years ago
New schema
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 PATCH_SCHEDULE_LABEL_JT PLJT on PLJT.LABEL_ID = L.ID
join PATCH_SCHEDULE PS on PLJT.PATCH_SCHEDULE_ID = PS.ID
join IM_CRON on IM_CRON.ID = PS.IM_CRON_ID
where IM_CRON.ENABLED = '1' )
Posted by:
JasonEgg
9 years ago
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' )