How to put hyperlinks in a custom SQL built report in KACE K1000?
Hi, I'm trying to create report which has machine names in it. I'd like to make the names links to the pages of those machines in the inventory so a user can easily click on the machine name when looking at the report to be directed to the machine's inventory page. I've already figured out how to construct the link but KACE doesn't allow inserting HTML tags into the custom SQL codes. It converts the special characters "<>' to their HTML encodes. Does anyone know how I can make KACE to create links for me?
I tried this SQL code but KACE still doesn't make it a clickable link:
SELECT CONCAT('http://kbox.it.ed.nyu.edu/adminui/machine.php?ID=',MACHINE.ID) as LINK FROM MACHINE
This is what I got from the HTML export: