How can I export from the cmdb_ci table and include the sys_id?

[glj0892]

I need to export any CIs created on the 20th February from the cmdb_ci table and I also need to include the sys_id of each record in the exported data. I cannot seem to find a way to include the sys_id field in to the list view. Any assistance would be appreciated. 

[#2]

Please see this post.

TLDR

1) Navigate to sys_ui_list_element and create a new record adding sys_id to cmdb_ci

2) Clear your cache by going to the /cache.do url

3) Load cmdb_ci table and reset your list view using 'Reset to column defaults'

[ersureshbe]

Hi,

You can extract it as XML file. It will display with sys_id.

Regards,

Suresh.

[emir]

How many records are you expecting to need sys id for? There might be a really easy solution for this