Is there a way to determine the last login date of users in Xtraction?
Run the following query against the Xtraction database
SELECT [User].[UserId],
[User].[Username],
[User].[FirstName],
[User].[LastName],
[User].[EmailAddress],
[User].[Locale],
[UserSession].[UserSessionId],
[UserSession].[LoginTime],
[UserSession].[LastPing],
[UserSession].[IPAddress]
FROM [User]
JOIN [UserSession]
ON [User].[UserId] = [UserSession].[UserId]
WHERE [User].[Username] = 'ENTER USER NAME HERE'
ORDER BY LoginTime DESC