Name in AssignmentPro: User's Most Recent Successful Login (View)
Name in Database: vwEQ_USER_LAST_SUCCESSFUL_SIGNIN
Description inc. recommended uses and limitations: Returns the details of the user's most recent successfully login into the system. When using this view, to be used successfully, it cannot be joined to any other table in the system. If this table is to be used, it should be selected as the report type's Base Table and no additional data sources should be added.
Tables used in the view:
CLASSIFICATION
USER
USER_SIGNIN_HISTORY
Fields contained in the view:
User Details
User ID
User Type
First Name
Last Name
Email Address
Account Expiration Date
Locked Date
Lock Reason
History Details
Sign in Date
Sign In Status
User ID Used
Click here for details on how to create a user report to return all fields for a given name in the database.