How to add bulk users in a particular assignment group in servicenow

[Nikhil kumar ma]

Hi,

I have to add around 150 users in a particular assignment group with the help of import set in ServiceNow.

Please help me in how to do that with the help of import sets.

Thanks and regards,

Nikhil

[Tony Chatfield1]

Hi, I would recommend you start by reading the vendor documentation and working through the learning material available on the developer portal.

The basic steps are load your data into a temporary/import table.
Map your import data to your target table coalescing on unique record values (with users this is often user name or email address) using direct field mapping and transform scripts (if required).
Run your transform script against the loaded data.

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/import-sets/reference/import-sets-landing-page.html

https://developer.servicenow.com/dev.do#!/learn/courses/sandiego/app_store_learnv2_importingdata_sandiego_importing_data_into_servicenow

[Aman Kumar S]

Hey,

I think you should create a data source firstly for the users, and create two transform map with target table as Users(sys_user) and Group membership(sys_user_grmember) table.

First run the user transform map since, you will need those information before you assign them to a group .

Then move on to Group membership transform map. This has only two fields, User and Group

[Community Alums]

Hi @Nikhil kumar maan ,

First save user details in CSV or xls format file only...Give the Column name as Group and User.

Then Goto Load data.Choose option of create a new table and create a temp table..Then Load file and click on sumbit.

Click on "create Transform Map" .Then choose target table as sys_user_grmember table and click on automap matching fields.

After that click on transform ...

You can check transform history in Transform History of transform is complete.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[sarikas1]

I did as per the steps provided and getting the status as below.