how to import 1 lakh users to sys_user table in single go

[M Iftikhar]

Hello @GRH,

To import a large number of users (like 1 million) into the sys_user table, the recommended approach is to use the Import Set + Transform Map method & not direct inserts or scripts. 

• Prepare your source file  typically a CSV or Excel file with all user details (name, email, user ID, department, etc.). 
• Create an Import Set Table  load the file into ServiceNow using System Import Sets > Load Data. 
• Create a Transform Map map fields from the import set table to the sys_user table. 
• Run the Transform use the Run Transform option to push the data into the sys_user table. 

Performance Tip: 

• Break the file into batches (for example, 25k records per batch) if performance slows down. 
• Avoid using scripts with GlideRecord.insert() for such large data loads. 
• Disable unnecessary business rules, workflows, or notifications during import to improve performance. 
• Use the “Coalesce” field (like user_name or email) to avoid duplicates. 

If you’re doing this regularly or at scale, consider using IntegrationHub  or MID Server data load for better control and performance. 

If my response helped, please mark it as the accepted solution so others can benefit as well.   

[M Iftikhar]

Hello @GRH,

Did you get a chance to review the post? Was it useful?

If this answered your question, please consider marking it as the Accepted Solution so others in the community can benefit from it as well.