Video Screencast Help

ServiceDesk 7.5: Adding multiple users to group

Created: 26 Feb 2013 • Updated: 27 Feb 2013 | 3 comments
bold's picture
This issue has been solved. See solution.
Is it possible to add multiple users simultaniously to one group in process manager or may be using some sql query?
Operating Systems:

Comments 3 CommentsJump to latest comment

TGiles's picture

The user interface does not allow for the adding of multiple users in one process. You will need to add them one user at a time.

Making the addition by SQL should be possibly by adding the necessary information to the UserGroups table. 

reecardo's picture

The table that stores the User Group relationship is the UserGroup table... inserting a row into that table would look like this:

insert into UserGroup (UserGroupID, UserID, GroupID)
values (NEWID(), '<user id>', '<group id>')

To make the SQL easier (not having to manually fetch IDs) you could make the INSERT look like the following:

insert into UserGroup (UserGroupID, UserID, GroupID)
values (NEWID(),

(SELECT UserID FROM [User] WHERE PrimaryEmail = ''),

(SELECT GroupID FROM [Group] WHERE GroupName = 'Administrators'))

This way you can specify something more meaningful, like the PrimaryEmail/GroupName

bold's picture

Perfect! That's what I needed to know.