Users
Query the available users on your sharepoint site.
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 |
| AadObjectId_NameId | String | ||
| AadObjectId_NameIdIssuer | String | ||
| String | |||
| Expiration | String | ||
| IsEmailAuthenticationGuestUser | Bool | ||
| IsShareByEmailGuestUser | Bool | ||
| IsSiteAdmin | Bool | ||
| UserId_NameId | String | ||
| UserId_NameIdIssuer | String | ||
| UserPrincipalName | String | ||
| LinkedAlerts | String | ||
| LinkedGroups | String | ||
| LoginName | String | The login name of the user. | |
| Title | String | The Title of the user. | |
| IsHiddenInUI | Boolean | A boolean indicating if the user is hidden in UI. | |
| GroupId | Int | The group id the user is added to. |