JDBC Driver for PingOne

Build 24.0.9175

Groups

The groups in the environment.

View-Specific Information

SELECT

Reading data from this entity requires Read Group/dir:read:group permissions.

We recommend using the built-in Client Application Developer role.

The 本製品 uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.

  • Id supports the following operators: =, IN.

All other filters are processed client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM Administrators.Groups WHERE Id = '13344eb0-1d6a-4715-9800-fce13f591925';
SELECT * FROM Administrators.Groups WHERE Id IN ('13344eb0-1d6a-4715-9800-fce13f591925', '76a9afd6-fd1c-4d55-9e84-7eea805f05c5');

In order to read the TotalUsersCount and TotalChildGroupsCount columns from this entity, the Id column must be specified in the criteria as shown in the examples above, otherwise null values will be pushed in the result set for these columns.

Columns

Name Type References Description
Id [KEY] String The group identifier (UUID).
Name String The name of the group.
Description String The group's description.
PopulationId String Populations.Id The identifier (UUID) of the population in which the group belongs to. If 'null' or empty, then it means the group belongs to the environment and not to a specific population in the environment.
DirectUsersCount Integer The number of users which are directly related with the group (don't belong to child groups).
DirectChildGroupsCount Integer The number of groups which are directly related with the group (are not child groups of child groups).
TotalUsersCount Integer The total number of users present in the group (including those from child groups).
TotalChildGroupsCount Integer The total number of groups present in the group (including child groups of child groups).
EnvironmentId String Information.Environments.Id The identifier (UUID) of the environment in which the group exists.
CreatedAt Datetime The time at which the group was created.
UpdatedAt Datetime The time at which the group was last updated.
DynamicMembersFilter String A SCIM filter that determines which users are dynamically added to the group.
HasAdminRoles Boolean Boolean value indicating whether there are any administrator roles assigned to the group.
CustomData String User-defined custom data for the group. This information is represented in JSON format (aggregate).
SourceId String The group identifier as defined in the source/external system. Populated when the group is created with Just In Time (JIT) provisioning.
SourceType String The type of the source/external system from which the group originates. Populated when the group is created with Just In Time (JIT) provisioning. Possible values are: 'GATEWAY' and 'IDP'.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175