Exporting Sys id in place of reference field 'Display value'

[Naresh27]

While exporting list of active incidents in excel, I need Caller sys_id in place of caller Display value. the use case is same with Assigned to and Assignment group.

Can we able to export reference fields with sys id's.

Thanks

[SanjivMeher]

This post should be helpful

https://developer.servicenow.com/blog.do?p=/post/exporting-data-with-sys-ids/

[Naresh27]

we are on Helsinki. Links does says its impossible to add sys id prior to jakarta versions. do you know any workaround

[SanjivMeher]

Did you check the section '

ADD THE SYS ID TO THE OUTPUT USING SYSPARM_DEFAULT_EXPORT_FIELDS

'

which has an example which should work prior to Jakarta as well

[Jaspal Singh]

Hi Nandan.

You may find link helpful.

Thanks,

Jaspal Singh

hit Helpful or Correct on the impact on the impact of reponse.