How to get sys ids of all groups in ServiceNow in excel format

[taqdeer]

Hi All,

I want to export the all group sys ids in the form of excel sheet. I have tried doing it through reports but was not able to add the required fields on report. I was able to do that in Classic View earlier but now I am in New UI view and I am not able to see the list collector to select the required fields and get exported. Please help me on achieving this.Below is the screenshot and I want sys id to display in the highlighted portion.

[Chander Bhusha1 · Accepted solution]

Hi Taqdeer,

You can append the url of while export like this:

https://<instance_name>.service-now.com/incident_list.do?EXCEL&sysparm_default_export_fields=all

Refer the links below.

https://hi.service-now.com/kb_view.do?sysparm_article=KB0691394

https://community.servicenow.com/community?id=community_question&sys_id=5a444f29dbd8dbc01dcaf3231f96...

Mark helpful and correct it it helps.

Thanks,

CB

[Chander Bhusha1]

Follow these steps as well for getting sysid in report:

1. Go to module System UI -> Lists

2. Select the record for the Table and view you want to modify (e.g. incident table, default view).(Select the report as well).

3. In the List Elements related list, add sys_id in the position you want

4. In your application navigator, type cache.do

mark helpful and correct 

Thanks,

CB

[Ankur Bawiskar]

Hi,

below URL should allow you to download the excel file when you hit this URL

https://<instanceName>.service-now.com/sys_user_group_list.do?EXCEL&sysparm_default_export_fields=sys_id

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Muralidharan BS]

Hi Taqdeer,

Right click on any column label on sys_user_group table > import > check update > click on create excel temple.

The last column will be your sys_id. This will work for most of the tables. 

Kindly mark my response correct and helpful if my suggestion resolved your query,

Thanks

Murali