Users
Manages SharePoint users, allowing updates, deletions, and retrieval of user details. Important for keeping SharePoint user management up-to-date.
Table Specific Information
Select
Retrieves all users created for the SharePoint Account:
SELECT * FROM Users
You can retrieve Users that belong to a specific Group. In this case specify the Group Name:
SELECT * FROM Users WHERE [Group] = "GroupName"
Or you can retrieve Users that have a specific Role. In this case specify the Role Name:
SELECT * FROM Users WHERE [Role] = "RoleName"
Columns
| Name | Type | ReadOnly | Description |
| ID | String | True |
A unique identifier assigned to the user. Useful for referencing users in queries and permission management. |
| LoginName# [KEY] | String | False |
The login name of the user, typically in DOMAIN\\username format. Helps authenticate and identify users within SharePoint. |
| 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. |
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 |
| Group | String |
The group to which the user is being added, selected from, or deleted. This is an input-only value; either Group or Role must be specified for inserts and selects, but both are optional for deletions. |
| Role | String |
The role to which the user is being added, selected from, or deleted. This is an input-only value; either Group or Role must be specified for inserts and selects, but both are optional for deletions. |