Links to data in ServiceNow in exported Excel report

[Kris Sherer]

How can I export data to Excel and include active links to the data in ServiceNow? I might want to share a list of incidents or knowledge articles that would allow the recipient to click each link. 

[ARG645]

Krish,

I guess the best way to do it would be

1. Create a new field on the incident/knowledge tables of type URL

2. Make it a "Calculated" field

3. Put the following line in the "Calculation"

"https://your_instance_name.service-now.com/nav_to.do?uri=incident.do?sys_id=" + current.sys_id

I did the same and it worked for me. And i believe there is no OOB way to do it.

References: https://community.servicenow.com/community?id=community_question&sys_id=375ff2a9db58dbc01dcaf3231f961956

Hope this helps

-Aman Gurram

[ARG645]

Please close this thread by marking the appropriate answer as correct, so that it will help other community members in future. Thank you, Aman Gurram

[Kris Sherer]

Hi,

We have not had a chance to try this yet for me to say this is "correct". It is helpful, however, and I have marked it as such. Thanks! 

[Tracy Davis]

The only way I know of to do this would be to create and share a report (this would only be accessible by someone within your organization with SN access).

A list view and report can both be exported to excel, or a report could be published for sharing, but those options wouldn't allow users to drill into the details.

Once you export to Excel you lose the interactive capability.