how to get sys_id of multiple records ?

Mathews1
Tera Contributor

I would like to get sys_id of 100 incident records. Is there a table or any other way to get the list of sys_id for records

1 ACCEPTED SOLUTION

Just export the records to XML-->open the XML with excel



Let me know if you have any questions.



Thanks


Pradeep Sharma


View solution in original post

17 REPLIES 17

Thanks Pradeep, solution looks good and I was able to export the data with sys_id field.



Thanks again


I am glad it finally worked for you


Would you mind marking my answer as correct.



Thanks


Pradeep Sharma


Hi Pradeep Sharma,

 

I would like to know incident,problem,change these table having the sys_id .if it is having the sys id how would i know it .

 

 

 

 

Regards,

Jagadeesh

can you use this method for other tables like change , cmdb_ci and problem . Or is this only available for incident table?


Hi JoanC TwainM



You can use this for other tables as well.



Thanks,


Pradeep Sharma