OrgSsoConnectionDeleted
Returns only org_sso_connection_deleted activities.
View-Specific Information
Select
This view always requests the org_sso_connection_deleted activity type. Type is fixed and cannot be changed in the query.
The actor union is flattened into ActorType and nullable Actor* detail columns. Fields that do not apply to the row's actor variant are null.
The connector uses the Claude Compliance API to process WHERE clause conditions built with the following columns and operators server-side. The rest of the filter is processed client-side within the connector.
The API processes supported ordering server-side. Unsupported ordering, grouping, and offsets are processed client-side within the connector. Without an ORDER BY clause, the API returns results newest-first.
| Column | Supported Operators |
| ActorId, ActorUserId | =, IN |
| OrganizationId, OrganizationUuid | =, IN |
| CreatedAt | >, >=, <, <= |
- ORDER BY CreatedAt ASC or DESC
- LIMIT
SELECT Id, CreatedAt, ActorType, ActorUserId FROM OrgSsoConnectionDeleted WHERE CreatedAt >= '2026-01-01T00:00:00Z' LIMIT 100;
SELECT * FROM OrgSsoConnectionDeleted WHERE OrganizationUuid = 'abcdef01-2345-6789-abcd-ef0123456789' AND ActorId = 'user_123' LIMIT 100;
Columns
| Name | Type | Description |
| Id [KEY] | String | The activity Id. |
| CreatedAt | Datetime | Activity time. Filterable with created_at ranges. |
| OrganizationId | String | Organization Id filterable via organization_ids. |
| OrganizationUuid | String | Organization UUID filterable via organization_ids. |
| ActorType | String | The actor union discriminator. |
| ActorEmailAddress | String | The email address for user_actor or anthropic_actor. |
| ActorUserId | String | The user Id for user_actor. Filterable through user_ids. |
| ActorWorkosEventId | String | The WorkOS event Id for scim_directory_sync_actor. |
| ActorDirectoryId | String | The identity-provider directory Id for scim_directory_sync_actor. |
| ActorIdpConnectionType | String | The identity-provider connection type for scim_directory_sync_actor. |
| ActorIpAddress | String | The source IP address for the actor variant. |
| ActorUserAgent | String | The source user agent for the actor variant. |
| Type | String | Always org_sso_connection_deleted. |
| ConnectionId | String | Deleted SSO connection Id. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ActorId | String | Filters with actor_ids. |