Allows the creation, deletion and retrieval of SharePoint security groups. Essential for managing user permissions and access control.

Table Specific Information

SELECT

Retrieves all groups created in the SharePoint Account:

SELECT * FROM Groups

Retrieve all groups with the specified names in your SharePoint Account:

SELECT * FROM Groups WHERE [Name] = 'Group1'
SELECT * FROM Groups WHERE [Name] IN ('Group1', 'Group2')

Retrieve the groups in which a specific user belongs.

SELECT * FROM Groups WHERE [UserLoginName] = "LoginName"

Retrieve the groups which have a specific role assigned to them.

SELECT * FROM Groups WHERE [RoleName] = "RoleName"

INSERT

You can create groups by specifying writable (ReadOnly=false) columns in the INSERT statement as shown in the query example below. Note that some columns are always required, while other columns can be optionally specified.

INSERT INTO Groups(Name, Description, DefaultUserLoginName, OwnerName, OwnerType) VALUES('Testing Group 5', 'Testing Group 5.', 'RIDDLERSP2013\\administrator', 'Testing Group 4', 'group')

DELETE

You can delete a group by specifying the Name column in the criteria as shown in the query example below:

DELETE FROM Groups WHERE Name = 'Group1'

Columns

Name	Type	ReadOnly	Description
Name [KEY]	String	False	The name of the group. Helps identify the group within SharePoint.
Id	String	True	The unique identifier of the group.
Description	String	False	A brief description of the group. Useful for understanding its purpose and membership.
OwnerId	String	True	The unique identifier of the group owner.
OwnerType	String	False	Specifies whether the owner is a user or another group. Helps define group management hierarchy. The allowed values are user, group.
UserLoginName	String	True	A filter for reading the groups in which a specific user belongs. If this column is not specified in the criteria, it will have null values.
RoleName	String	True	A filter for reading the groups which have a specific role assigned to them. If this column is not specified in the criteria, it will have null values.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
OwnerName	String	The name of the user or group who should be the owner of the group to create. This is a write-only column which should be used only in 'INSERT' statements.
DefaultUserLoginName	String	The user name of the default user for the group. This value should be in the format DOMAIN\\username. This is a write-only column which should be used only in 'INSERT' statements.