Export List of Records into CSV with SysID

[salvadormarchan]

Hello All,

I really need help on the scenario that one of Managers is asking me. They wanted to export CSV files from a List of Records including the SysID (32 long string ID). I can find it individually but not as part of a list.

Please advise how to do this.

Thank you in advance.

Dor Marchan
one month-old newbie admin

[tony_fugere]

I presume you mean CSV file, right?

So, sys_id is hidden for your own safety... 🙂

However, you can export the data as XML to get the sys_id and then maybe have a custom XLST transform it into the format that would result in a CSV.

Any ServiceNow folks out there want to 1-up me and tell us how to get sys_id in our CSV/XLS data exports?

[salvadormarchan]

(Right...apologize for the mispelling...)

Thank you for the reply. Let me check if this may fit his requirement. Thanks again...

[drp]

Hello,

I have similar requirement to export sys id in Excel or CSV. Can you please share steps if any of this approach worked ?

Thanks !!

[CapaJC]

Yeah, there's no way through the UI, you gotta hack the list.

1) System UI --> Lists, find the one you want (with the right table name, view, domain, etc.). Open it.

2) You'll see the related list of columns for that list. You can create a new record in the related list for sys_id.

3) Once you do, you'll need to flush the list cache, since manually adding a sys_ui_list_element record won't do it automatically. Best way to do this is simply to personalize a different list in any way. Don't modify the list you just hacked - I'm not sure whether doing that will remove the sys_id column you just poked in.