SQL query based smart label
I have used the SQL query from the report called "Devices Needing Reboot" to create a smart label for the devices which are stuck on reboot pending in the patch cycle, so I can create automatic alerts for the users to reboot.
The query in the report is working fine so as from the MySQL workbench tool but it doesn't work properly for the smart label, it attaches the labels to the machines which don't have reboot pending status, I see all the devices in label with and without reboot pending status.
Is anyone came across with this type of issue?
I am running Version: 10.1.99 on the server and 10.0.113 for the agents.
select DISTINCT NAME, IP, LAST_SYNC, UPTIME from MACHINE join KBSYS.KONDUCTOR_TASK KT on KT.KUID = MACHINE.KUID and KT.TYPE like 'kpatch%' and KT.PHASE ='reboot pending' order by MACHINE.NAME
If you create a smart label using the wizard it selects these columns:
MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID
I'm pretty sure that last MACHINE.ID as TOPIC_ID is the most important bit, but I always set my SQL smart labels to return those columns.