Groups
User groups.
View Specific Information
Required Scopes
The Scope property must contain the following to have permission to query this view: okta.groups.read
Select
The connector uses the Okta API to process WHERE clause conditions built with the following columns and operators.
- Id supports the '=' and 'LIKE (starts with)' operators
- Created supports the '>', '>=', '=', '<=', and '<' operators
- LastUpdated supports the '>', '>=', '=', '<=', and '<' operators
- LastMembershipUpdated supports the '>', '>=', '=', '<=', and '<' operators
- Type supports the '=' and 'LIKE (starts with)' operators
- ProfileName supports the '=' and 'LIKE (starts with)' operators
- ProfileDescription supports the '=' and 'LIKE (starts with)' operators
All other filters are processed client-side within the connector.
For example, the following queries are processed server-side:
SELECT * FROM Groups WHERE Id = '00g1emaKYZTWRYYRRTSK' SELECT * FROM Groups WHERE LastUpdated > '2024-08-01'
Columns
| Name | Type | Description |
| Id [KEY] | String | Id of the group |
| Created | Datetime | When the group was created |
| LastUpdated | Datetime | When the group's profile was last updated |
| LastMembershipUpdated | Datetime | When the group's memberships were last updated |
| ObjectClass | String | Determines the group's profile |
| Type | String | Determines how the profile and memberships are managed |
| ProfileName | String | The group's profile name |
| ProfileDescription | String | The group's profile description |