Smart Label for Devices with Reboot Pending status after Deploy
I am attempting to create a smart label for all machines who are pending a reboot after the previous patch run. I attempted to use the sql provided in
which also happens to be the same SQL used to create the prefab report "Devices needing reboot".
The problem is, when I run the report I get different results then when viewing by smart label with the same SQL. When viewing by label, some machines which aren't even part of our patch schedules are listed. The report on the other hand is correct. Any Ideas?
Here is the SQL:
select NAME, IP, LAST_SYNC, UPTIME
join KBSYS.KONDUCTOR_TASK KT on KT.KUID = MACHINE.KUID and KT.TYPE like 'patch%' and KT.PHASE ='reboot pending'
Thanks in advance.