LoginHistory
Logs user login attempts, tracking access details such as IP addresses and login timestamps.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier of the login history record. | |
| UserId | String |
User.Id | ID of the user associated with the login event. |
| LoginType | String | Type of login used, such as UI, API, or SSO. | |
| SourceIp | String | IP address from which the login was initiated. | |
| LoginUrl | String | URL used for the login request. | |
| NetworkId | String |
Network.Id | ID of the Experience Cloud site associated with this record. |
| AuthenticationServiceId | String | ID of the AuthenticationService associated with this record. | |
| LoginGeoId | String |
LoginGeo.Id | ID of the LoginGeo associated with this record. |
| TlsProtocol | String | Field containing TlsProtocol information. | |
| CipherSuite | String | Field containing CipherSuite information. | |
| OptionsIsGet | Bool | Field containing OptionsIsGet information. | |
| OptionsIsPost | Bool | Field containing OptionsIsPost information. | |
| Browser | String | Browser used during the login session. | |
| Platform | String | Operating system or platform used during the login session. | |
| Status | String | Result of the login attempt, such as Success or Failed. | |
| Application | String | Application or interface used for the login. | |
| ClientVersion | String | Version of the client application used during login. | |
| ApiType | String | Type of API used for login, if applicable. | |
| ApiVersion | String | Version of the API used during the login session. | |
| CountryIso | String | Field containing CountryIso information. | |
| AuthMethodReference | String | Field containing AuthMethodReference information. | |
| LoginSubType | String | Type classification for LoginSub. | |
| ForwardedForIp | String | Field containing ForwardedForIp information. | |
| AuthContextClassRef | String | Authentication Context Class Reference (ACR) value provided by the identity provider during login. | |
| LoginTime | Datetime | Date and time when the login occurred. |
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 | |
| 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. |