1.how to add a 100 users at a time to group.

saikrishna mail
Tera Contributor

how to add 100 users   at a time to group? its possible?How?

12 REPLIES 12

Mihir Mohanta
Kilo Sage

You can run background script to add number of users at a time to   specific group.



Thanks,


Mihir


Hai Mihir Mohanta


How ? pls tell me procedure.


All the users are related with each other or not related ?If related , how ?


Can you find all these users by running some filter in users table ?



Thanks,


Mihir


Harneet Sital
Mega Sage
Mega Sage

Hi Saikrishna,



Follow the steps to import users if you have them in xls or csv format :


1. Create a csv or excel file with Group name and User names.


2. Now import data into ServiceNow. To create a import data set : Importing Data Using Import Sets - ServiceNow Wiki


3. Create transform maps of the same loaded data. Transform data into the sys_user_grmember table. To create a new transform map : Creating New Transform Maps - ServiceNow Wiki


Manoj Kumar16
Giga Guru

Hi SaiKrishna,



There is a table named- sys_user_grmember


there are two fields in this table - user and group both are reference fields. so you can prepare an excel sheet with user names in one column and group names in another column and create an import set and then use transform map to upload the records in sys_user_grmember table.