JDBC Driver for Azure Active Directory

Build 22.0.8509

GroupMembers

GroupMembers table for Azure AD data provider.

Table Specific Information

Select

Query the GroupMembers table by retrieving everything from Azure AD or by specifying GroupId with = and IN operators. You can filter results by GroupId and MemberId.

  • GroupId supports the '=' and IN operators.
  • MemberId supports the '=' and IN operators.

For example, the following queries are processed server side:

SELECT * FROM GroupMembers WHERE GroupId IN ('4729c5e5-f923-4435-8a41-44423d42ea79', 'acabe397-8370-4c31-aeb7-2d7ae6b8cda1')

SELECT * FROM GroupMembers WHERE GroupId = '4729c5e5-f923-4435-8a41-44423d42ea79'

Columns

Name Type Description
GroupId [KEY] String The Id of the Group.
MemberId [KEY] String The User Id of the member listed.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509