Adds specified users to a group in the LDAP directory. The group and user entries are identified by their Distinguished Names (DNs).

Stored Procedure Specific Information

AddMembersToGroup

Adding members to groups with LDAP requires updating the Member field of the Group object with all the UserDNs to be added to the group. The UserDNs input must be provided as a JSON file.

You can provide the UserDNs in either of the following ways:

To add the UserDNs via a temporary table:

INSERT INTO UserDNs#TEMP ([DN]) 
SELECT DN FROM [User] WHERE Id LIKE '%Test%'
EXEC AddMembersToGroup @GroupId = '1|CN=jhbkrb5,OU=Kerberos,OU=TIBCODV,DC=NS3,DC=local', @UserDNs = 'UserDNs#TEMP'

To provide the JSON body of the object-array directly:

EXEC AddMembersToGroup @GroupId = '1|CN=jhbkrb5,OU=Kerberos,OU=TIBCODV,DC=NS3,DC=local', 
				 @UserDNs = '[{"DN": "CN=Test3333,DC=NS3,DC=local;CN=Test33,DC=NS3,DC=local"}]'

Input

Name	Type	Description
GroupId	String	Specifies the unique identifier (ID) of the group to which users will be added. This ID should correspond to an existing group record in the LDAP directory.
UserDNs	String	An aggregate or temporary table containing the Distinguished Names (DNs) of users to be added to the specified group. Each DN must correspond to an existing user record in the LDAP directory.

Result Set Columns

Name	Type	Description
Success	String	Returns a boolean status indicating whether the users were successfully added to the specified group.