Users
Represents users and their roles in the SharePoint site or group.
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 | Unique identifier for each user in the SharePoint environment. | |
| LoginName | String | The unique login name used by the user to access the SharePoint environment. | |
| Title | String | The display name or title associated with the user. | |
| IsHiddenInUI | Bool | Indicates whether the user is hidden from the SharePoint user interface. | |
| GroupId | Int | The identifier of the group to which the user belongs. | |
| AadObjectId_NameId | String | Azure Active Directory (AAD) object ID representing the user's unique identifier. | |
| AadObjectId_NameIdIssuer | String | The issuer of the Azure Active Directory (AAD) NameId for the user. | |
| String | Primary email address associated with the user. | ||
| EmailWithFallback | String | An alternate or fallback email address for the user if the primary is unavailable. | |
| Expiration | String | Specifies the expiration date of the user's access, if applicable. | |
| HexCid | String | A hexadecimal representation of the user's client ID. | |
| IsEmailAuthenticationGuestUser | Bool | Indicates if the user is a guest authenticated via email. | |
| IsShareByEmailGuestUser | Bool | Indicates if the user is a guest invited via email for sharing purposes. | |
| IsSiteAdmin | Bool | Specifies whether the user has administrative rights for the site collection. | |
| UserId_NameId | String | The unique identifier for the user in SharePoint's user ID system. | |
| UserId_NameIdIssuer | String | The issuer of the user's ID in SharePoint's user ID system. | |
| UserPrincipalName | String | User Principal Name (UPN) for the user, usually an email-style identifier. | |
| PrincipalType | Int | Defines the type of principal, using bitwise values: None=0, User=1, DistributionList=2, SecurityGroup=4, SharePointGroup=8, All=15. |