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

[gputker]

There is a very simple way to do this but first let me advise as to why some of the aforementioned methods are not so great...

1) Using the Easy Import capability - this is good but only if you are dealing with say 2-4K records.  Any more than this and the easy importer just presents a blank screen.  Also, if you are running any sort of advanced filter on your list of records, Easy Import will load a blank screen when you attempt to get the data.

2) Using a URL command (e.g. sys_user_group.do?EXCEL&sysparm_default_export_fields=all).  This is also really good but only if you're working with 2-4K records.  Any more than this and ServiceNow will truncate the excel file export based on its size.

The very best and easiest way to do this is to create a Database View.  Within the database view add the table you wish to extract Sys_IDs from.  Once you have added your table, open it and add the fields to the table you wish to see (of which sys_id will be one of them).  There is no need for a 'Where clause' because you are not actually conducting a DB join.

Click 'Try it' on the DB View and watch a list of your data appear with SYS_ID available.  You can then export this data into excel.

Whats great about this method is that its very easy and non invasive (like a script or a new table can be) AND you can filter your data first within ServiceNow (using fields data you have added) and then export it.  Screen Shots attached in order!