ODBC Driver for Microsoft Exchange

Build 23.0.8839

GroupMembers

Group Members table for Exchange data provider.

Table Specific Information

Groups require Administrator permissions. To work with them, you must create your own custom OAuth App and set the appropriate OAuthClientId and OAuthClientSecret. In this app, you must configure it to request the GroupMember.Read.All and the GroupMember.ReadWrite.All permissions. This can be done at https://apps.dev.microsoft.com, or in the App Registrations panel at http://portal.azure.com.

To authorize GroupMembers permissions, an administrator must grant the GroupMembers permissions for your organization at large. This can be done via the administrator authorization endpoint. Simply have the administrator navigate to the following web page and grant permissions. Then run the OAuth authorization as normal afterwards.

https://login.microsoftonline.com/common/adminconsent?client_id=[YourClientId]&redirect_uri=http://localhost:33333

Note that if your organization has multiple tenants, you may replace the /common/ in the url with the tenant id to indicate which tenant to grant permissions for.

Select

The 本製品 uses the Microsoft Exchange API to process WHERE clause conditions. The rest of the filter is executed client-side in the 本製品.

For example, the following query is processed server-side:

SELECT * FROM GroupMembers 

Columns

Name Type Description
Id [KEY] String
GroupId String
AssistantName String
BusinessPhones String
Classification String
CreatedDateTime Datetime
CreationOptions String
DeletedDateTime Datetime
Description String
DisplayName String
ExpirationDateTime Datetime
GivenName String
GroupTypes String
IsAssignableToRole Boolean
JobTitle String
Mail String
MailEnabled Bool
MailNickname String
MembershipRule String
MembershipRuleProcessingState String
MobilePhone String
OfficeLocation String
OnPremisesDomainName String
OnPremisesLastSyncDateTime Datetime
OnPremisesNetBiosName String
OnPremisesProvisioningErrors String
OnPremisesSamAccountName String
OnPremisesSecurityIdentifier String
OnPremisesSyncEnabled Bool
PreferredDataLocation String
PreferredLanguage String
ProxyAddresses String
RenewedDateTime Datetime
SecurityEnabled Bool
Surname String
UserPrincipalName String
Visibility String

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