Users
Retrieves a list of users and their assigned roles within a SharePoint site or group. Important for managing permissions and user activity tracking.
Table Specific Information
Select
SELECT * FROM Users // Fetch all the Users SELECT * FROM Users WHERE GroupId = 5 // Fetch a user for a particular Group
Columns
| Name | Type | References | Description |
| Id [KEY] | Int | A unique numeric identifier assigned to each user in the SharePoint environment. Useful for referencing users in workflows and permissions management. | |
| LoginName | String | The unique login name of the user accessing SharePoint. Helps authenticate and identify users within the system. | |
| Title | String | The display name or title associated with the user. Useful for showing user-friendly names in SharePoint interfaces. | |
| IsHiddenInUI | Bool | Indicates whether the user is hidden from the SharePoint user interface. Useful for managing background or system accounts. | |
| GroupId | Int | The identifier of the group the user belongs to. Helps manage user roles and permissions within groups. | |
| AadObjectId_NameId | String | The Azure Active Directory (AAD) object ID representing the user's unique identifier. Useful for integrating SharePoint with Azure AD. | |
| AadObjectId_NameIdIssuer | String | The issuer of the AAD NameId for the user. Helps verify the authentication source. | |
| String | The primary email address associated with the user. Useful for communication and notification purposes. | ||
| EmailWithFallback | String | An alternate or fallback email address for the user if the primary email is unavailable. Helps ensure redundancy in communication. | |
| Expiration | String | Specifies the expiration date of the user's access, if applicable. Useful for managing temporary access permissions. | |
| HexCid | String | A hexadecimal representation of the user's client ID. Helps in system tracking and authentication processes. | |
| IsEmailAuthenticationGuestUser | Bool | Indicates whether the user is a guest authenticated via email. Useful for identifying external users. | |
| IsShareByEmailGuestUser | Bool | Indicates whether the user is a guest invited via email for sharing purposes. Helps track external collaborators. | |
| IsSiteAdmin | Bool | Specifies whether the user has administrative rights for the SharePoint site collection. Helps manage site ownership and security. | |
| UserId_NameId | String | The unique identifier for the user in SharePoint’s user ID system. Useful for tracking user activities and permissions. | |
| UserId_NameIdIssuer | String | The issuer of the user's ID in SharePoint’s user ID system. Helps validate identity sources. | |
| UserPrincipalName | String | The User Principal Name (UPN) for the user, typically in email format. Useful for authentication and user identification. | |
| PrincipalType | Int | Defines the type of principal, using bitwise values: None=0, User=1, DistributionList=2, SecurityGroup=4, SharePointGroup=8, All=15. Helps categorize different types of users and groups. |