How to import users, roles and group

[manjusha]

Hello all,

I want to import users roles and group from excel sheet into service now users , roles and group 

table.

Please give me the brief description for how to achieve this.

Regards,

Manjusha

[wcasas]

You can go to each table, right click the header and select import. This will give you the ability to export a template as an excel. You can fill in the info there. Then import that file.

[Jaspal Singh]

Hi Manjusha,

For that we need to use Data source. Link should give you a better understanding for getting it work.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

[John Snow1]

Since you are using an excel spreadsheet you are going to have to break it up.
1.Import the groups to the groups table with an import set/Transform map 
2.Assign the roles to the groups manually.
3.Then import the users with an import set, and break the users into their appropriate groups via a transform script.

This link may help with the transform script.
https://community.servicenow.com/community?id=community_question&sys_id=bff1c3e9db98dbc01dcaf3231f96....

Best of Luck

John.

[manjusha]

Hi,

Can you please share me the transform script to break users into appropriate group.

Regards,

Manjusha.