How to export 150,000 users to excel sheet

[Alon Grod]

Hi,

I have 150,000 users in my sys_user table and Im trying to export them to excel sheet and then import them to a different instance. When I click on export, its says that I can only export 10,000. Is there any way that I can Increase the number to 150,000 for both import and export? Right now its giving me to export only 10,000.

 

[Maik Skoddow]

Hi @Alon Grod 

there is a valid reason for that restriction, as the Excel file has to be built completely within the memory of the application server before it can be downloaded. If that file grows too much, the server could crash due to missing memory.

But there is a scripted approach built by a user. Please find all information at https://davidmac.pro/posts/2021-07-02-sn-bulk-export/

Maik

[Mark Roethof]

Hi there,

Since you are mentioning exporting/importing to another instance. Have you considered other methods? Like creating an XML, or actually setting up a minor integration between the instances?

Is this also a one-time thing, or do you want to do this more often?

[Prince Arora · Accepted solution]

@Alon Grod 

As per the product documentation, this is the system property which is handled the "glide.ui.export.limit" export count, if it will not find in the system property you can create this property as string and mention the count as 2000000

https://docs.servicenow.com/en-US/bundle/vancouver-platform-administration/page/administer/exporting...

ServiceNow has set a limit of 10,000 records. If you exceed this limit, it could lead to a slowdown in the process.

To manage this, you might consider a solution: break down the task by selecting batches of 10,000 records each and attempt to import them separately. This approach can help maintain a smoother and more efficient import process.

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful based on the Impact.

[Alon Grod]

@Prince Arora hi what about Import 150,000 from excel?