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

[Slava Savitsky]

To have sys_id included in an export, use "sysparm_default_export_fields=all" URL parameter as explained here:

Exporting Data - ServiceNow Wiki

[eashwar]

Hello All,

i tried 2 proposed solution but no luck.

1. system UI , added sys_id - i see sys_id in list view but i dont see it when i download

2. sys_user_group_list.do?CSV&sysparm_default_export_fields=all didnt download sys_id

am i missing something here ?

Thanks,

Eashwar

[Slava Savitsky]

Hi Eashwar,

I have tried the second option on my personal dev instance just now and it did export the sys_ids as expected. What version is your instance running on?

[santhoshaitha]

Hello Eashwar,

The second method worked for me! Thanks a lot

Is there any possibility that we restrict the number of columns and still include Sys_id?

Because we have more than 150+ columns and more than 1.5 lakh records. So this makes it difficult to export all records.

Regards,

Santhosh

[gowthami_tavval]

Hi Eashwar,

Can you help me with the process to export data from a table with sys_ids.

Thanks in Advance