How to export 150,000 users to excel sheet

Alon Grod
Tera Expert

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.

 

WhatsApp Image 2023-08-27 at 07.23.53.jpeg

 

1 ACCEPTED SOLUTION

Prince Arora
Tera Sage
Tera Sage

@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

 

PrinceArora_0-1693111591665.png

 

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.

 

View solution in original post

5 REPLIES 5

@Alon Grod 

Have you tried to import 1,50,000 ? Do you get any error?