LoginEvent
Represents a user login event captured for auditing and security monitoring.
Columns
| Name | Type | References | Description |
| Id | String | Unique identifier for the record. | |
| CreatedDate | Datetime | Date and time when the record was created. | |
| EventIdentifier | String | Unique identifier for the event. | |
| UserId | String |
User.Id | ID of the User associated with this record. |
| Username | String | Username of the user associated with this record. | |
| EventDate | Datetime | Date and time when the event occurred. | |
| RelatedEventIdentifier | String | ID of a related event. | |
| PolicyId | String | ID of the transaction security policy. | |
| PolicyOutcome | String | Result of the transaction security policy evaluation. | |
| EvaluationTime | Double | Time taken to evaluate the transaction security policy. | |
| SessionKey | String | Unique key identifying the user session. | |
| LoginKey | String | Unique key identifying the login session. | |
| SessionLevel | String | Security level of the user session. | |
| SourceIp | String | IP address from which the request originated. | |
| AdditionalInfo | String | Field containing AdditionalInfo information. | |
| ApiType | String | Type classification for Api. | |
| ApiVersion | String | Field containing ApiVersion information. | |
| Application | String | Field containing Application information. | |
| AuthServiceId | String | ID of the AuthService associated with this record. | |
| Browser | String | Field containing Browser information. | |
| HttpMethod | String | Field containing HttpMethod information. | |
| CountryIso | String | Field containing CountryIso information. | |
| ForwardedForIp | String | Field containing ForwardedForIp information. | |
| LoginLatitude | Double | Latitude coordinate for Login address geolocation. | |
| LoginLongitude | Double | Longitude coordinate for Login address geolocation. | |
| Country | String | Country portion of the address. | |
| City | String | City portion of the address. | |
| PostalCode | String | Postal code portion of the address. | |
| Subdivision | String | Field containing Subdivision information. | |
| CipherSuite | String | Field containing CipherSuite information. | |
| ClientVersion | String | Field containing ClientVersion information. | |
| LoginGeoId | String | ID of the LoginGeo associated with this record. | |
| LoginHistoryId | String | ID of the related login history record. | |
| LoginType | String | Type classification for Login. | |
| LoginUrl | String | Field containing LoginUrl information. | |
| NetworkId | String |
Network.Id | ID of the Experience Cloud site associated with this record. |
| Platform | String | Field containing Platform information. | |
| Status | String | Status of the record. | |
| TlsProtocol | String | Field containing TlsProtocol information. | |
| UserType | String | Type classification for User. | |
| ProfileId | String |
Profile.Id | ID of the profile associated with this record. |
| RoleId | String |
UserRole.Id | ID of the role associated with this record. |
| AuthMethodReference | String | Field containing AuthMethodReference information. | |
| LoginSubType | String | Type classification for LoginSub. | |
| AuthContextClassRef | String | Authentication Context Class Reference (ACR) value provided by the identity provider during login. |
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 | |
| UserIdType | String | Specifies the type of the 'UserId' polymorphic field to use in the statement. | |
| UserIdExternalFieldName | String | Specifies the external field name of the 'UserId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| SOQL | String | Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. |