"List" Report scheduled export featuring links to each record in the email body/attachment

[pbusch]

When a load a "List" report of Incidents in ServiceNow , I can click the 'Number' and the hyperlink resolves to that record.

Is anyone aware of how I go about configuring a daily export of this report , so that when a user opens the email they have the ability to click the featured 'Number' and load the record this way from the email body or attachment ?

[AshishKM]

Hi @pbusch,

Yes, In email notifications, you can use the {URI_REF} variable to include a link to the record.

If its individual email per record then user {URI_REF} else prepare a tabular list using the email script's template.print method.

var url = '<a href="' + gs.getProperty('glide.servlet.uri') + 'sp?id=ticket&table=' + current.sys_class_name + '&sys_id=' + current.sys_id + '">Link</a>';  
  template.print(url);  

Refer this 

https://www.servicenow.com/community/itsm-forum/email-notification-link-to-incident-in-serviceportal...

-Thanks,

AshishKM