ServiceDesk

Hello,

A lot of the out of box reports in ServiceDesk contain a hyperlink to open the incident number that is selected.  I created a simple report using SQL Syntax.  How can I make the Process ID Field a hyperlink that opens the selected incident?

Thank you.

You can't add that link in an SQL report.  There is no option to include process actions, which is how you normally include it.  There is a workaround, though.  

1. Create a view using your query (make sure you have the SessionID as a column)
2. Create a profile using the view you just created
3. Use the profile in your report, and then you can include process actions to get the link

I posted some instructions on how to create and use a profile in a report in this thread:  https://www-secure.symantec.com/connect/forums/last-posted-date-reporting-service-desk

Sounds like a plan.  Thanks!