- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-06-2019 09:57 PM
When exporting a list of incident tickets to Excel, can I include link information to the incident ticket itself in Excel?
If I can't do it with OOTB, I'm thinking of the following method. Is it possible?
When creating an incident ticket, link information to itself is stored in the URL type field of incident record itself.
Link information is considered to be the following information.
https://CUSTOMERx.service-now.com/nav_to.do?uri=incident.do?sys_id=SYS_ID of incident ticket
Regards,
Yousuke
Solved! Go to Solution.
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-06-2019 10:14 PM
Hi,
yes that is the only way to do this; since url is not stored at record level
you can store that using before insert BR on incident table
Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-06-2019 10:14 PM
Hi,
yes that is the only way to do this; since url is not stored at record level
you can store that using before insert BR on incident table
Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-07-2019 12:39 AM
Hi Abkur,
Thank you for your answer.
I am glad to confirm no way by using OOB and my idea is a right way.
There are several people who gave the same answers, but you were the fastest, so I chose your answer as the correct answer.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-06-2019 10:17 PM
Well, I don't think there is any OOB field where you could get the URL from while exporting. You can a field on the table just to generate the URL of the record.
However, if you don't prefer creating another field on incident record just for the URL. You could form the URL in Excel after exporting it. You can use the number parameter to generate the URL.
The URL based on number field would be:
https://instance-name.service-now.com/incident.do?sysparm_query=number=INCXXXXXXX
And that URL could be formed in the last column of the excel sheet, by using CONCAT function:
=CONCAT("https://instance-name.service-now.com/incident.do?sysparm_query=number=",A1)
Where A is the column where the numbers were stored in the excel sheet.
Hope this helps!
Cheers,
Manish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-07-2019 12:41 AM
Hi Manish,
Thank you for your information.
Your answer was very helpful.
However, there was a person who provided an answer with the same content earlier, so I chose that as the Correct Answer.
I appreciate your understanding in this matter.
Regards,
Yousuke