Users

Manage SharePoint users, allowing updates, deletions, and retrieval of user details. Important for keeping SharePoint user management up-to-date.

Table Specific Information

Retrieves all users created for the SharePoint Account:

SELECT * FROM Users

Retrieve all users with the specified login names in your SharePoint Account:

SELECT * FROM Users WHERE [LoginName] = 'DOMAIN\\User1'
SELECT * FROM Users WHERE [LoginName] IN ('DOMAIN\\User1', 'DOMAIN\\User2')

Retrieve users that belong to a specific group:

SELECT * FROM Users WHERE [GroupName] = "GroupName"

Retrieve users that have a specific role assigned to them:

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

You can update user data by specifying the LoginName column in the criteria as shown in the query example below:

UPDATE Users SET Notes = 'User 1 notes.' WHERE LoginName = 'DOMAIN\\User1'

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

DELETE FROM Users WHERE LoginName = 'DOMAIN\\User1'


Name	Type	ReadOnly	Description
LoginName [KEY]	String	True	The login name of the user, typically in DOMAIN\\username format. Helps authenticate and identify users within SharePoint.
Id	String	True	A unique identifier assigned to the user. Useful for referencing users in queries and permission management.
Name	String	False	The display name of the user. Useful for showing user-friendly names in SharePoint interfaces.
Email	String	False	The primary email address associated with the user. Used for communication and notifications.
IsInDomainGroup	Boolean	True	Indicates whether the user is a member of a domain group. Helps manage group-based access control.
IsSiteAdmin	Boolean	True	Indicates whether the user has administrative privileges for the SharePoint site. Helps identify high-level access users.
Notes	String	False	Optional notes or additional information related to the user. Useful for internal documentation and tracking.
SecurityId	String	True	The security identifier (SID) assigned to the user. Helps in managing and tracking user permissions.
GroupName	String	False	A filter for reading the users in a specific group. If this column is not specified in the criteria, it will have null values.
RoleName	String	False	A filter for reading the users which are assigned a specific role. If this column is not specified in the criteria, it will have null values.