Why does this sql work for reporting but not smart labels?
the sql below works for a report by populating with the machines we want, however when we try to make a smart label it does not work anyone know why? this sql is supposed to get all the machine names that have a patch status of suspended, that are not in patch schedules with the word detect and that have our software CReplacement installed.
SELECT DISTINCT M.NAME AS Machine
FROM PATCHLINK_SCHEDULE P LEFT JOIN KBSYS.KONDUCTOR_TASK K ON P.KONDUCTOR_TASK_TYPE = K.TYPE LEFT JOIN MACHINE M ON K.KUID = M.KUID LEFT JOIN PATCHLINK_SCHEDULE_MACHINE_STATUS PSMS ON PSMS.MACHINE_ID = M.ID
WHERE P.LAST_RUN <> 0 AND DESCRIPTION not like '%Detect%' AND Phase like 'suspended' AND M.NAME IN (SELECT MACHINE.NAME
FROM MACHINE, SOFTWARE, MACHINE_SOFTWARE_JT
WHERE MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID AND MACHINE_SOFTWARE_JT.SOFTWARE_ID=SOFTWARE.ID AND SOFTWARE.DISPLAY_NAME LIKE 'CReplacement')
There are no answers at this time