Users
The OneDrive table Users in which an admin user can view the users details.
Users Information
Projection is done server-side. Basic select query is supported e.g.:
SELECT * FROM Users
Using this view an admin user can list all other users details.
Columns
| Name | Type | References | Description |
| id [KEY] | String | ||
| deletedDateTime | Datetime | ||
| accountEnabled | Bool | ||
| businessPhones | String | ||
| city | String | ||
| companyName | String | ||
| country | String | ||
| createdDateTime | Datetime | ||
| department | String | ||
| displayName | String | ||
| employeeHireDate | Datetime | ||
| employeeId | String | ||
| employeeOrgData_costCenter | String | ||
| employeeOrgData_division | String | ||
| employeeType | String | ||
| givenName | String | ||
| identities | String | ||
| imAddresses | String | ||
| isResourceAccount | Bool | ||
| jobTitle | String | ||
| lastPasswordChangeDateTime | Datetime | ||
| String | |||
| mailNickname | String | ||
| mobilePhone | String | ||
| officeLocation | String | ||
| onPremisesDistinguishedName | String | ||
| onPremisesDomainName | String | ||
| onPremisesExtensionAttributes_extensionAttribute1 | String | ||
| onPremisesExtensionAttributes_extensionAttribute10 | String | ||
| onPremisesExtensionAttributes_extensionAttribute11 | String | ||
| onPremisesExtensionAttributes_extensionAttribute12 | String | ||
| onPremisesExtensionAttributes_extensionAttribute13 | String | ||
| onPremisesExtensionAttributes_extensionAttribute14 | String | ||
| onPremisesExtensionAttributes_extensionAttribute15 | String | ||
| onPremisesExtensionAttributes_extensionAttribute2 | String | ||
| onPremisesExtensionAttributes_extensionAttribute3 | String | ||
| onPremisesExtensionAttributes_extensionAttribute4 | String | ||
| onPremisesExtensionAttributes_extensionAttribute5 | String | ||
| onPremisesExtensionAttributes_extensionAttribute6 | String | ||
| onPremisesExtensionAttributes_extensionAttribute7 | String | ||
| onPremisesExtensionAttributes_extensionAttribute8 | String | ||
| onPremisesExtensionAttributes_extensionAttribute9 | String | ||
| onPremisesImmutableId | String | ||
| onPremisesLastSyncDateTime | Datetime | ||
| onPremisesProvisioningErrors | String | ||
| onPremisesSamAccountName | String | ||
| onPremisesSecurityIdentifier | String | ||
| onPremisesSyncEnabled | Bool | ||
| onPremisesUserPrincipalName | String | ||
| otherMails | String | ||
| postalCode | String | ||
| preferredLanguage | String | ||
| state | String | ||
| streetAddress | String | ||
| surname | String | ||
| userPrincipalName | String | ||
| userType | String |