Can I include link information to the incident ticket itself in Excel?

Yousuke Murakam
Mega Contributor

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

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

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

Manish Vinayak1
Tera Guru

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

 

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