Importing Assignment Groups

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-17-2009 12:17 PM
Hi All,
I am hoping somebody can advise me on the best way to import Assignment Groups and their members into Service Now. I am wanting to populate workgroups using an Excel Spreadsheet. These are the fields I am wanting populated:
Name
Manager
Group Email
Parent Group
Description
Role
Group Members
I seem to be having problems with the "Groups Members" part. What is the symbol or character I need to use between names and do I list the users login name or there full name?
I would appreciate any help you can provide.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-17-2009 04:01 PM
You're on the right track Scottie, but the relationship between Groups and Users is handled on a separate table.
You need to import your groups (sys_user_group), then import group members (sys_user_grmember) with two columns "group" and "user", to make the join.
Note: this way works well for the initial load, but not so well for ongoing maintenance of group membership.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-18-2009 01:08 AM
Great thanks for that. Another question. If I want to load multiple users into a group how should I setup my spreadsheet? Do I need to put each user in a seperate cell within my SS or do I put a ',' or ';' or something similar in to seperate the users?
Also, when I add the users into the spreadsheet do I use the fullname of the user or the user ID?
Thanks in advance.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-19-2009 04:39 PM
With sys_user_grmember you need a new row for each join you make; so 10 people in 1 group would need 10 rows. Being user references, the system is very flexible on how you select your users (by name, userid, or sysid), but userid would be preferred to avoid ambigious names (John Smith etc).
If you already have some group assignments made, create a module to browse the Group Member table to get an understanding how it works.