mail_script:

vargr=newGlideRecord('sys_properties');varinstanceName='deloittecnapp';gr.addQuery('name','instance_name');gr.query();if(gr.next()){instanceName=gr.getValue('value');}vartbl=current.getTableName();//gs.info("jasontestinstanceName:"+instanceName);//gs.info("jasontesttbl:"+tbl);template.print("<atitle=\"Link\"href=\"https://"+instanceName+".service-now.com/sp?view=portal&id=ticket&table="+tbl+"&sys_id="+current.sys_id+"\">${number}</a>");