kace Reports for listing machines in patch schedule
Hello, i have quite a few patch schedules for mac, windows dekstop, laptops, servers etc.
However some of them have smart labels and some just list the individual machines.
I would like to have a report listing the what devices are listed in each patch schedule, there is one already setup in kbox called patch schedules and its selected devices however this only lists the patch schedule where the devices are smart labels and not the individual ones.
Therefore does anyone know how to create another report that lists the same but includes the patch schedules where individual devices are added?
This is the best I could get.
This will give you a report for all devices within all patch schedules that have Status of Completed, you can take away the completed if you like but it will show you duplicate machines.
SELECT PATCHLINK_SCHEDULE_ID, NAME FROM PATCHLINK_SCHEDULE_RUN_MACHINE JOIN MACHINE ON PATCHLINK_SCHEDULE_RUN_MACHINE.MACHINE_ID = MACHINE.ID WHERE PATCHLINK_SCHEDULE_RUN_MACHINE.STATUS = "completed"
You can also add after completed
and PATCHLINK_SCHEDULE_ID = 3
Just replace 3 with the Individual ID's of each schedule
Hope this kind of helps.