ODBC Driver for Microsoft Planner

Build 24.0.9063

Users

Represents various ways a user can view assigned tasks.

Table Specific Information

Select

The 本製品 will use the Microsoft Planner API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • Id supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Users WHERE UserId = '9523f1-aa0-4fe17-a9w7b-6860618adf'

Columns

Name Type Description
UserId [KEY] String The ID of the user.
aboutMe String The label About Me corresponds to this field.
accountEnabled Bool The label account enabled corresponds to this field.
ageGroup String Typically used to set the age group of the user.
assignedLicenses String The licenses that are assigned to the user, including inherited licenses.
assignedPlans String The plans that are assigned to the user.
authorizationInfo_certificateUserIds String Label Authorization Info Certification User IDs corresponds to this field.
birthday Datetime The birthday of the user.
businessPhones String The telephone numbers for the user.
city String The city where the user is located.
companyName String The name of the company that the user is associated with.
consentProvidedForMinor String Typically used to set whether consent was obtained for minors.
country String The country/region where the user is located.
createdDateTime Datetime The date and time the user was created.
creationType String Specifies the method by which the user account was created.
customSecurityAttributes String An open complex type that holds the value of a custom security attribute that is assigned to a directory object.
department String The name of the department in which the user works.
deviceEnrollmentLimit Int Label Device Enrollment Limit corresponds to this field.
displayName String The name displayed in the address book for the user.
employeeHireDate Datetime The date and time when the user was hired or will start work in a future hire.
employeeId String The employee identifier assigned to the user by the organization.
employeeLeaveDateTime Datetime The date and time when the user left or will leave the organization.
employeeOrgData_costCenter String Represents cost center organization data associated with the employee.
employeeOrgData_division String Represents division organization data associated with the employee.
employeeType String Captures enterprise worker type.
externalUserState String This property represents the invited user's invitation status.
externalUserStateChangeDateTime Datetime Shows the timestamp for the latest change to the externalUserState property.
faxNumber String The fax number of the user.
givenName String The first name of the user.
hireDate Datetime The hire date of the user.
identities String Specifies the identities that can be used to sign in to this user account.
imAddresses String The instant message voice-over IP session initiation protocol addresses for the user.
interests String A list for the user to describe their interests.
isResourceAccount Bool Do not use. This is reserved for future use.
jobTitle String The user's job title.
lastPasswordChangeDateTime Datetime The last time the user changed their password or when their password was created, whichever date is the most recent.
legalAgeGroupClassification String Typically used by enterprise applications to determine the legal age group of the user.
licenseAssignmentStates String State of license assignments for this user.
mail String The Simple Mail Transfer Protocol address for the user.
mailboxSettings_archiveFolder String Label Mailbox Settings Archive Folder corresponds to this field.
mailboxSettings_automaticRepliesSetting_externalAudience String Label Mailbox Settings Automatic Replies External Audience corresponds to this field.
mailboxSettings_automaticRepliesSetting_externalReplyMessage String Label Mailbox Settings Automatic Replies External Reply Message corresponds to this field.
mailboxSettings_automaticRepliesSetting_internalReplyMessage String Label Mailbox Settings Automatic Replies Internal Reply Message corresponds to this field.
mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_dateTime String Label Mailbox Settings Automatic Replies Scheduled End Date Time corresponds to this field.
mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_timeZone String Label Mailbox Settings Automatic Replies Scheduled End Date Timezone corresponds to this field.
mailboxSettings_automaticRepliesSetting_status String Label Mailbox Settings Automatic Replies Status corresponds to this field.
mailboxSettings_dateFormat String Label Mailbox Settings Automatic Replies Date Format corresponds to this field.
mailboxSettings_delegateMeetingMessageDeliveryOptions String Label Mailbox Settings Delegate Meeting Message Delivery Options corresponds to this field.
mailboxSettings_language_displayName String Label Mailbox Settings Language Display Name corresponds to this field.
mailboxSettings_language_locale String Label Mailbox Settings Language Locale corresponds to this field.
mailboxSettings_timeFormat String Label Mailbox Settings Time Format corresponds to this field.
mailboxSettings_timeZone String Label Mailbox Settings Time Zone corresponds to this field.
mailboxSettings_userPurpose String Label Mailbox Settings User Purpose corresponds to this field.
mailboxSettings_workingHours_daysOfWeek String Label Mailbox Settings Working Hours Days of Week corresponds to this field.
mailboxSettings_workingHours_endTime Time Label Mailbox Settings Working Hours End Time corresponds to this field.
mailboxSettings_workingHours_startTime Time Label Mailbox Settings Working Hours Start Time corresponds to this field.
mailboxSettings_workingHours_timeZone_name String Label Mailbox Settings Working Hours Time Zone Name corresponds to this field.
mailNickname String The mail alias for the user.
mobilePhone String The primary cellular telephone number for the user.
mySite String The URL for the user's site.
officeLocation String The office location in the user's place of business.
onPremisesDistinguishedName String Contains the on-premises Active Directory distinguished name or DN.
onPremisesDomainName String Contains the on-premises domainFQDN, also called dnsDomainName synchronized from the on-premises directory.
onPremisesExtensionAttributes_extensionAttribute1 String Contains Extension Attributes 1.
onPremisesExtensionAttributes_extensionAttribute10 String Contains Extension Attributes 10.
onPremisesExtensionAttributes_extensionAttribute11 String Contains Extension Attributes 11.
onPremisesExtensionAttributes_extensionAttribute12 String Contains Extension Attributes 12.
onPremisesExtensionAttributes_extensionAttribute13 String Contains Extension Attributes 13.
onPremisesExtensionAttributes_extensionAttribute14 String Contains Extension Attributes 14.
onPremisesExtensionAttributes_extensionAttribute15 String Contains Extension Attributes 15.
onPremisesExtensionAttributes_extensionAttribute2 String Contains Extension Attributes 2.
onPremisesExtensionAttributes_extensionAttribute3 String Contains Extension Attributes 3.
onPremisesExtensionAttributes_extensionAttribute4 String Contains Extension Attributes 4.
onPremisesExtensionAttributes_extensionAttribute5 String Contains Extension Attributes 5.
onPremisesExtensionAttributes_extensionAttribute6 String Contains Extension Attributes 6.
onPremisesExtensionAttributes_extensionAttribute7 String Contains Extension Attributes 7.
onPremisesExtensionAttributes_extensionAttribute8 String Contains Extension Attributes 8.
onPremisesExtensionAttributes_extensionAttribute9 String Contains Extension Attributes 9.
onPremisesImmutableId String This property is used to associate an on-premises Active Directory user account.
onPremisesLastSyncDateTime Datetime Indicates the last time at which the object was synced with the on-premises directory.
onPremisesProvisioningErrors String Errors when using Microsoft synchronization product during provisioning.
onPremisesSamAccountName String Contains the on-premises SAM Account Name synchronized from the on-premises directory.
onPremisesSecurityIdentifier String Contains the on-premises security identifier for the user that was synchronized from on-premises to the cloud.
onPremisesSyncEnabled Bool This field is true if this user object is currently being synced from an on-premises Active Directory.
onPremisesUserPrincipalName String Contains the on-premises userPrincipalName synchronized from the on-premises directory.
otherMails String A list of other email addresses for the user.
passwordPolicies String Specifies password policies for the user.
passwordProfile_forceChangePasswordNextSignIn Bool Specifies that the user will be forced to change the password on the next sign-in.
passwordProfile_forceChangePasswordNextSignInWithMfa Bool Specifies that the user will be forced to change the password on the next sign-in with multi-factor authentication.
passwordProfile_password String Specifies the password profile for the user.
pastProjects String A list for the user to enumerate their past projects.
postalCode String The postal code for the user's postal address.
preferredDataLocation String The preferred data location for the user.
preferredLanguage String The preferred language for the user.
preferredName String The preferred name for the user.
provisionedPlans String The plans that are provisioned for the user.
proxyAddresses String Label Proxy Addresses corresponds to this field.
responsibilities String A list for the user to enumerate their responsibilities.
schools String A list for the user to enumerate the schools they attended.
securityIdentifier String Security identifier of the user.
serviceProvisioningErrors String Errors published by a federated service describing a nontransient, service-specific error regarding the properties or link from a user object.
showInAddressList Bool Label Show In Address List corresponds to this field.
signInActivity_lastNonInteractiveSignInDateTime Datetime Specifies the last non-interactive signed-in date and time of the sign-in for a given user.
signInActivity_lastNonInteractiveSignInRequestId String Specifies the last non-interactive signed-in request ID of the sign-in for a given user.
signInActivity_lastSignInDateTime Datetime Specifies the last signed-in date and time of the sign-in for a given user.
signInActivity_lastSignInRequestId String Specifies the last signed-in request ID of the sign-in for a given user.
signInSessionsValidFromDateTime Datetime Specifies any refresh tokens or session tokens issued before this time are invalid.
skills String A list for the user to enumerate their skills.
state String The state or province in the user's address.
streetAddress String The street address of the user's place of business.
surname String The user's last name.
usageLocation String A two-letter country code required for users that are assigned licenses due to legal requirements to check for availability of services in countries.
userPrincipalName String The user principal name of the user.
userType String A string value that can be used to classify user types in your directory.
authentication_id String The authentication ID of the user.
calendar_id String The calendar ID of the user.
cloudClipboard_id String The user's cloud clipboard ID.
drive_id String The user's OneDrive ID.
employeeExperience_id String The Employee Experiene ID of the user.
inferenceClassification_id String Specifies the classification of the user's messages based on explicit designations that override inferred relevance or importance.
insights_id String Specifies the relationships between a user and items.
manager_id String The ID of the user's manager.
onenote_id String The OneNote ID of the user.
outlook_id String The Outlook ID of the user.
photo_id String The user's profile photo ID.
planner_id String The user's planner ID.
presence_id String Label Presence ID corresponds to this field.
settings_id String Label Settings ID corresponds to this field.
teamwork_id String Label Teamwork ID corresponds to this field.
todo_id String Specifies the To Do services available to a user.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063