Why does my K1000 SQL report not create links to machines?
I have created a SQL report to bring back some results. the report appears to be working. however, unlike when you create a report from the wizard, or use one of the built in reports, when a machine name is in the list, it doesnt link to the machine's page on the k1000 like its suppose to. is there something else i have to put in the code? (by the way, i'm new to sql, so the code is probably ugly) any suggestions would be great!
S.DISPLAY_NAME, M.NAME AS Machine
FROM MACHINE M
ORG1.KBOT_LOG KL ON (KL.MACHINE_ID = M.ID)
MACHINE_SOFTWARE_JT MSJT ON (MSJT.MACHINE_ID = M.ID)
SOFTWARE S ON (S.ID = MSJT.SOFTWARE_ID)
((KL.KBOT_ID RLIKE '144|143')
AND (S.DISPLAY_NAME RLIKE 'JAVA')
AND (S.DISPLAY_NAME NOT RLIKE ('7 UPDATE 13|AUTO UPDATER|FX')))
ORDER BY DISPLAY_NAME