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.
