SsoLoginInitiated
Returns only sso_login_initiated activities.
View-Specific Information
Select
This view always requests the sso_login_initiated activity type. Type is fixed and cannot be changed in the query.
The actor is always an unauthenticated_user_actor. Its documented fields are flattened into ActorType, ActorUnauthenticatedEmailAddress, ActorIpAddress, and ActorUserAgent.
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 | =, IN |
| OrganizationId, OrganizationUuid | =, IN |
| CreatedAt | >, >=, <, <= |
- ORDER BY CreatedAt ASC or DESC
- LIMIT
SELECT Id, CreatedAt, ActorType, ActorUnauthenticatedEmailAddress FROM SsoLoginInitiated WHERE CreatedAt >= '2026-01-01T00:00:00Z' LIMIT 100;
SELECT * FROM SsoLoginInitiated 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. |
| ActorUnauthenticatedEmailAddress | String | The email address for unauthenticated_user_actor. |
| ActorIpAddress | String | The source IP address for the actor variant. |
| ActorUserAgent | String | The source user agent for the actor variant. |
| Type | String | Always sso_login_initiated. |
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. |