Skip to main content

logins

Creates, updates, deletes, gets or lists a logins resource.

Overview

Namelogins
TypeResource
Idlinode.profile.logins

Fields

The following fields are returned by SELECT queries:

The requested login object.

NameDatatypeDescription
idintegerRead-only The unique ID of this login object.
datetimestring (date-time)Read-only When the login was initiated. (example: 2018-01-01T00:01:01)
ipstring (ip)Read-only The remote IP address that requested the login. (example: 192.0.2.0)
restrictedbooleanRead-only True if the User that attempted the login was a restricted User, false otherwise.
statusstringRead-only Whether the login attempt succeeded or failed. (example: successful)
usernamestringRead-only The username of the User that attempted the login. (example: example_user)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_profile_loginselectReturns a login object displaying information about a successful account login from this user.

Learn more...

Learn more...
get_profile_loginsselectReturns a collection of successful account logins from this user during the last 90 days.

Learn more...

Learn more...

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription

SELECT examples

Returns a login object displaying information about a successful account login from this user.

Learn more...

Learn more...

SELECT
id,
datetime,
ip,
restricted,
status,
username
FROM linode.profile.logins
;