ServiceDesk

 View Only
  • 1.  ServiceDesk 7.5: Adding multiple users to group

    Posted Feb 26, 2013 08:49 AM

     

    Hello!
     
    Is it possible to add multiple users simultaniously to one group in process manager or may be using some sql query?
     


  • 2.  RE: ServiceDesk 7.5: Adding multiple users to group

    Broadcom Employee
    Posted Feb 26, 2013 09:25 AM

    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. 



  • 3.  RE: ServiceDesk 7.5: Adding multiple users to group
    Best Answer

    Posted Feb 26, 2013 09:38 AM

    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 = 'admin@symantec.com'),

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

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



  • 4.  RE: ServiceDesk 7.5: Adding multiple users to group

    Posted Feb 27, 2013 03:52 AM
    Perfect! That's what I needed to know.