Users
Lists users with OneDrive accounts in the organization, including user identifiers and profile 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 | Unique identifier for the user object in the directory. | |
| deletedDateTime | Datetime | Timestamp indicating when the user was deleted, if applicable. | |
| accountEnabled | Bool | Indicates whether the user's account is currently active and can sign in. | |
| businessPhones | String | List of business phone numbers associated with the user, separated by commas. | |
| city | String | City specified in the user's business or work address. | |
| companyName | String | Name of the user's employer or organization. | |
| country | String | Country or region specified in the user's address. | |
| createdDateTime | Datetime | Timestamp when the user account was created in the directory. | |
| department | String | Department the user belongs to within the organization. | |
| displayName | String | Full display name of the user, shown in directories and address books. | |
| employeeHireDate | Datetime | Date the user was hired, used in HR and compliance contexts. | |
| employeeId | String | Internal employee identifier assigned by the organization. | |
| employeeOrgData_costCenter | String | Cost center to which the user is assigned for accounting or budgeting purposes. | |
| employeeOrgData_division | String | Organizational division the user belongs to, such as Engineering or Sales. | |
| employeeType | String | Type of employment, such as FullTime, Contractor, or Temporary. | |
| givenName | String | User's first name or given name. | |
| identities | String | List of sign-in identities (such as email, user ID) associated with the user. | |
| imAddresses | String | List of instant messaging addresses (such as Skype or Teams), separated by commas. | |
| isResourceAccount | Bool | Indicates whether the account is used as a resource, such as a conference room or shared mailbox. | |
| jobTitle | String | Job title or role of the user in the organization. | |
| lastPasswordChangeDateTime | Datetime | Date and time the user last changed their password. | |
| String | Primary email address of the user. | ||
| mailNickname | String | Alias or mail nickname used in email routing and internal references. | |
| mobilePhone | String | User's mobile or cell phone number. | |
| officeLocation | String | User's office room number or location description. | |
| onPremisesDistinguishedName | String | Distinguished Name (DN) of the user in the on-premises Active Directory. | |
| onPremisesDomainName | String | Domain name of the on-premises environment where the user is managed. | |
| onPremisesExtensionAttributes_extensionAttribute1 | String | Custom extension attribute 1 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute10 | String | Custom extension attribute 10 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute11 | String | Custom extension attribute 11 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute12 | String | Custom extension attribute 12 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute13 | String | Custom extension attribute 13 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute14 | String | Custom extension attribute 14 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute15 | String | Custom extension attribute 15 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute2 | String | Custom extension attribute 2 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute3 | String | Custom extension attribute 3 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute4 | String | Custom extension attribute 4 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute5 | String | Custom extension attribute 5 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute6 | String | Custom extension attribute 6 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute7 | String | Custom extension attribute 7 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute8 | String | Custom extension attribute 8 from on-premises Active Directory. | |
| onPremisesExtensionAttributes_extensionAttribute9 | String | Custom extension attribute 9 from on-premises Active Directory. | |
| onPremisesImmutableId | String | Unique ID used to map the cloud user to the on-premises AD user object. | |
| onPremisesLastSyncDateTime | Datetime | Timestamp of the last sync operation from on-premises Active Directory. | |
| onPremisesProvisioningErrors | String | List of errors that occurred during provisioning or sync from on-premises AD. | |
| onPremisesSamAccountName | String | Security Account Manager (SAM) name used in Windows logon scenarios. | |
| onPremisesSecurityIdentifier | String | Security identifier (SID) for the user in the on-premises AD environment. | |
| onPremisesSyncEnabled | Bool | Indicates whether the user object is synchronized from on-premises Active Directory. | |
| onPremisesUserPrincipalName | String | User principal name (UPN) used in the on-premises environment. | |
| otherMails | String | List of additional email addresses associated with the user, separated by commas. | |
| postalCode | String | Postal or ZIP code of the user's business address. | |
| preferredLanguage | String | Preferred language for communications and system interfaces. | |
| state | String | State or province listed in the user's address. | |
| streetAddress | String | Street portion of the user's business address. | |
| surname | String | User's last name or family name. | |
| userPrincipalName | String | UPN used to log in, typically in the format [email protected]. | |
| userType | String | Type of user account, such as Member, Guest, or External. |