USER_AUTH

This table displays a log of sign in and sign out events, as well as failed authentication attempts. This information is also captured in the spectrum-security.log file. Sign out events are only captured if a user clicks Logout.

Important! Loftware Enterprise SP Auditing Schema (LOFTAUDIT) tables are read-only. Modifications to these tables could cause errors and prevent Loftware Enterprise SP from functioning.

Note: If you are using Loftware Cloud Enterprise SP, Loftware Cloud Operations may have assigned unique names for the reporting schema and the auditing schema for your Loftware Enterprise SP instance. Contact Loftware Cloud Operations for details.

Note: All timestamps are relative to the time on the database server.

Column Name	Type	Description
ID	Number	The internal identification number of a User Authorization. Key: Primary Key
ACTION	String	The type of action performed. LOGIN_FAILURE LOGIN_SUCCESS USER_LOGOUT
ACTION_DATE	Timestamp	The date and time when the action was performed.
IP_ADDRESS	String	The IP Address of the authorization event.
JVM_ID	Number	The JVM that the action was performed and audited on. In a single JVM environment this is 0.
REASON	String	For LOGIN_FAILURE, the reason the failure occurred.
SOURCE	String	Not used.
USER_ID	Number	The ID of the User in the USERS table.
USERNAME	String	The name of the User.