how to get sys_id of multiple records ?

[Mathews1]

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

[Pradeep Sharma]

Try this please

https://demo002.service-now.com/incident.do?EXCEL&&sysparm_view=ess&sysparm_default_export_fields=al...

NOTE:"sysparm_view=ess"//change this parameter as per your requirement.

Let me know if you have any questions.

Thanks

Pradeep Sharma

[Mathews1]

Hi Pradeep,

Yes I tried with ESS, Default and other views as well but still when the data gets exported it consist of the rows in the current view.

Is there any other way to get the data.

Thanks

[Pradeep Sharma]

Hi Mathews,

Try this https://demo002.service-now.com/incident.do?EXCEL&sysparm_default_export_fields=all

Note:If you are exporting CSV or Excel data and do not specify a view, the export uses the default list view. You can export all fields by setting the sysparm_default_export_fieldsparameter to all (available starting with the Dublin release). If you are exporting XML data, the export returns all fields unless you specify a particular view. Thesysparm_default_export_fields parameter has no effect on XML exports.

Thanks

Pradeep Sharma

[Mathews1]

Thanks Pradeep..

Can you please let me know how to get the same data in other versions prior to Dublin

Thanks

[Pradeep Sharma · Accepted solution]

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

Let me know if you have any questions.

Thanks

Pradeep Sharma