Export sys id

[kmickael]

Hi, 

We have configuration items in our CMDB.
We want to update them.

We are going to export this table and then update the excel file in order to import again.

which field is used for the merge?  Because the name of the ci will be potentially modified
Can we export the sys_id and the used in the transformation table during the import?

Thank you for your help

[Shashikant Yada · Accepted solution]

You need to go to the list view right click on it -> Import -> Update -> Create Excel Template

[Community Alums]

Hi,

I think it's not a best practice to change the sys ids of existing records. You should actually prefer creating new records.

[kmickael]

Hi thank for rreply 

I don't want to change the sys_id.

i just want to know the sys_id of record (make the Coalesce with the sys_id) to make an update of other field of the same record .

Exemple: 

update the version field 

Sys_id          name              version

1                 windows            seven

2                 Windows           xp

3                 Windows           10

[kmickael]

Any one know how i can export the sys_id with the ci class ?